Fetching Data Between 2 Dates: SQL

[RoboCop]

How to fetch records between two dates from the database using query..

Example: Table name: company

 
+--------+----------------+
| name       | jd         |
+--------+----------------+
| Google     | 2010-02-20 |
| Oracle     | 2010-02-15 |
| Microsoft  | 2010-02-05 |
| Apple      | 2010-02-02 |
| Technotip  | 2010-02-01 |
| ebay       | 2012-02-09 |
+--------+----------------+

[Basavaraj]

sql> select * from company where jd between ‘2010-02-01’ and ‘2010-02-15’;

 
+--------+----------------+
| name       | jd         |
+--------+----------------+
| Oracle     | 2010-02-15 |
| Microsoft  | 2010-02-05 |
| Apple      | 2010-02-02 |
| Technotip  | 2010-02-01 |
+--------+----------------+

[Author]

Posts