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:
sql, c, table, ant, date, data, time, struct, sed, type, structure, tutorial, field, state, ria, create, tab, for, ie, example, statement, to, exam, ld, between, bot, e, il, use, pe, im, from, in, sta, m, nt, tr, tween, em, me, rate, do, tor, xa, xamp, s, ee, etw, at, old, is, instant, ime, ll, mpl, ea, and, stat, str, tutor, tw, s, s, ri, th, st, ab, abl, ple, pl, nd, om, ol, o

«Previous Index Next»