Javatpoint Logo



Javatpoint Logo


SQL SELECT DATE is used to retrieve a date from a database. If you want to find a particular date from a database, you can use this statement.

For example: let's see the query to get all the records after '2013-12-12'.

Let's see the another query to get all the records after '2013-12-12' and before '2013-12-13' date.

If you want to compare the dates within the query, you should use BETWEEN operator to compare the dates.

Or if you are looking for one date in particular you can use. You should change the date parameter into the acceptable form.

Next TopicSQL Select Sum

Latest 4 Tutorials on JavaTpoint