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 |
+--------+----------+---------------------+

Related Tags for SQL Between Timestamp:
sql,  time,  map,  timestamp,  tutorial,  ria,  example,  to,  exam,  between,  e,  il,  im,  from,  sta,  m,  tr,  tween,  es,  me,  rate,  tor,  xa,  xamp,  s,  ee,  etw,  at,  ime,  ll,  mpl,  and,  stamp,  str,  tutor,  tw,  s,  s,  ri,  tam,  th,  st,  ap,  ple,  pl,  nd,  om,  o

More Tutorials from this section

• SQL Date, SQL Date Examples
• SQL Date
• MySQL By Date
• MySQL By Week
• Mysql date API
• Mysql Date Arithmetic
• Mysql Date in between
• Mysql Date Default
• Mysql date equal
• Mysql date field
• Mysql Date Filter
• Mysql Date Format codes
• Mysql Date Format Convert
• Mysql Date Format
• Mysql Date from Date
• Mysql Date and Time
• Mysql Date Functions
• Mysql Date Index
• Mysql Date Input
• Mysql Date To Java Date

Ask Questions?    Discuss: SQL Between Timestamp  

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):