Srinimf | Tech.Jobs.Biz.Success

Query to get latest date:

Select item, max(inventorydate) from table where inventorydate is < ‘6/30/2011′

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

Select item from table

where appl_date >= (Currentdate – 6 Years)

Selecting date between two dates:

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

References

edit
edit