SQL Between Timestamp
SQL Between Timestamp is used to return the time records of table in
database.
Understand with Example
The Tutorial map you to understand and illustrate an example from 'SQL
Between Timestamp'.To understand and grasp the example we create a table 'Stu_Table'
with required tablefields and datatypes respectively.
Create Table
CREATE TABLE Stu_Table (
Stu_Id varchar(2),
Stu_Name varchar(10),
Stu_Dob timestamp NOT NULL );
|
Insert Date Into Stu_Table
The insert into is used to add the records or rows to the table 'Stu_Table'.
Insert Into Stu_Table Values('1', 'Komal', '1984-10-27');
Insert Into Stu_Table Values('2', 'ajay', '1985-04-19');
Insert Into Stu_Table Values('3', 'Santosh', '1986-11-16');
|
Stu_Table
+--------+----------+---------------------+
| Stu_Id | Stu_Name | Stu_Dob |
+--------+----------+---------------------+
| 1 | Komal | 1984-10-27 00:00:00 |
| 2 | ajay | 1985-04-19 00:00:00 |
| 3 | Santosh | 1986-11-16 00:00:00 |
+--------+----------+---------------------+
|
Query
The Query below given is used to show only those records include time whose
stu_dob lies between '1984-01-01' And '1986-1-1'.
Select * From Stu_Table
Where Stu_Dob Between '1984-01-01' And '1986-1-1';
|
Result
+--------+----------+---------------------+
| Stu_Id | Stu_Name | Stu_Dob |
+--------+----------+---------------------+
| 1 | Komal | 1984-10-27 00:00:00 |
| 2 | ajay | 1985-04-19 00:00:00 |
+--------+----------+---------------------+
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
