1. We have moved to a new forum! There may be a few things not working properly so please let us know if you find a bug. Remember to use the bbCode [ sql ] tag for SQL statements.
New XenForo forum! Google Ads

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

Discussion in 'SQL - Questions and Answers' started by lowie, Jul 23, 2006.

  1. lowie Guest

    Dialect: SQL 92
    How to retrieve records which the date_column should be 36 months older than the current date?

    the date_column has the format MM/DD/YYYY.

    thanks,
    lowie, Jul 23, 2006
    #1

  2. Dimitar Guest

    Dialect: SQL 92
    SQL:

    
select * from dates_table where date_column < (current_date - interval 3 year)
    Dimitar, Aug 21, 2006
    #2

Share This Page