Select query between two given dates in MySQL, MS SQL

Its very easy to select records between two different date in MS SQL and MySQL. Same kind of query will work in both the SQL engines.

Here is the query note it down or memorize for the future use, Its very simple though.

Syntax:

SELECT * FROM tablename WHERE columname between ‘date1’ and ‘date2’;

Lets consider the below example table:

Table name: employee

Id Name Designation Dttime
1 Agurchand Software Engineer 2013-01-07 11:47:10
2 Babu Software Engineer 2013-01-02 01:06:00
3 Abhiesheik Broadcast Engineer 2013-01-10 18:04:02
4 Juki Content Writer 2012-12-27 06:16:32
5 Aparna Social Executive 2013-01-27 03:47:00
6 Arun Sofware Engineer 2012-12-27 08:12:10

 


SELECT * FROM employee WHERE Dttime between '2012-01-01' and '2012-02-01';

The above query will return the below result:

Id Name Designation DateTime
1 Agurchand Software Engineer 2013-01-07 11:47:10
2 Babu Software Engineer 2013-01-02 01:06:00
3 Abhiesheik Broadcast Engineer 2013-01-10 18:04:02
5 Aparna Social Executive 2013-01-27 03:47:00

I hope this would have helped you! Thanks for coming here!

Add a Comment

Your email address will not be published. Required fields are marked *