SQL query where Mydate should be less than 2 years

Question

I have one date column MyDate and I want those records in which MyDate should be less than current date by 2 years.

Answer 1

if DB Server = MS SQL , then try :-

select *
from myTable
where MyDate < dateadd(year, -2, getdate())

Answer 2

For DB2 you can use this

MYDATECOLUMN < CURRENT DATE - 2 YEAR