SQL Recipes a FREE cookbook of SQL queries and examples - View Single Post - How to retrieve records which the date column should be 36 months older than the current date?

Thread: How to retrieve records which the date column should be 36 months older than the current date?

View Single Post

#2 (permalink)

Old

08-21-2006, 02:39 AM

Dimitar

Posts: n/a

Default

SQL 92 answer. Re: How to retrieve records which the date column should be 36 months older than the current date?

[sql]
select * from dates_table where date_column < (current_date - interval 3 year)
[/sql]

Edit/Delete Message

Reply With Quote