Home Sql SQL Between Datetime



SQL Between Datetime
Posted on: December 20, 2008 at 12:00 AM
The Tutorial illustrate an example from SQL Between Date time. The example create a table 'Stu_Table'.

SQL Between Datetime

     

The Tutorial illustrate an example from SQL Between Date time. The example create a table 'Stu_Table'. The create table statement is used to create a table 'Stu_Table'. The data type for the field Stu_Dob is date time. The Date Time structure tell you an instant in time, hold both date and a time. 

Create Table Stu_Table

Create Table Stu_Table (Stu_Id varchar(2), Stu_Name varchar(15), Stu_Dob datetime);

Insert Data Into Stu_Table

The insert into add the records or rows to the table 'Stu_Table'.

insert into stu_table values('1', 'Komal', '1984-10-27 02:10:00');
insert into stu_table values('2', 'Ajay', '1985-04-19 12:10:25');
insert into stu_table values('3', 'santosh', '1986-11-16 23:46:34');

Stu_Table

+-----------+----------+---------------------+
| Stu_Table | Stu_Name | Stu_Dob             |
+-----------+----------+---------------------+
| 1         | Komal    | 1984-10-27 02:10:00 |
| 2         | Ajay     | 1985-04-19 12:10:25 |
| 3         | Santosh  | 1986-11-16 23:46:34 |
+-----------+----------+---------------------+

Query

The given below query return you the records from table 'Stu_Table' .The Where Clause restrict the records on the basis of Stu_Dob as specified in condition.

Select * From Stu_Table
Where Stu_Dob Between '1984-01-01 00:00:00' And '1986-1-1 00:00:00';

Result

+-----------+----------+---------------------+
| Stu_Table | Stu_Name | Stu_Dob             |
+-----------+----------+---------------------+
| 1         | Komal    | 1984-10-27 02:10:00 |
| 2         | Ajay     | 1985-04-19 12:10:25 |
+-----------+----------+---------------------+

Related Tags for SQL Between Datetime:
sqlctableantdatedatatimestructsedtypestructuretutorialfieldstateriacreatetabforieexamplestatementtoexamldbetweenboteilusepeimfrominstamnttrtweenemmeratedotorxaxampseeetwatoldisinstantimellmpleaandstatstrtutortwssrithstabablpleplndomolo


More Tutorials from this section

Ask Questions?    Discuss: SQL Between Datetime   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.