Tricky SQL Queries On Dates

Query to get the latest date:

Select item, max(inventory_ date)
from table
where inventory_date is < '6/30/2011'

Query to retrieve not more than 6 years from application date:

Select item from a table
where appl_date >= (Currentdate - 6 Years)

SQL Query to Selec a date between two dates:

WHERE CP.ActionDate 
BETWEEN '19/12/2012' 
AND '1/17/2013'

Relates Posts