Syntax help - Subtract two years from current date?

[KA NMC]

I need help with the syntax below to subtract two years from the current date

select oe_hdr.customer_id
from oe_hdr
where year (oe_hdr.order_date) >= year (getdate()-2 )

Thanks

[ck9663]

I need help with the syntax below to subtract two years from the current date

select oe_hdr.customer_id
from oe_hdr
where year (oe_hdr.order_date) >= year (getdate()-2 )

Thanks

use datepart

something like:

select oe_hdr.customer _id
from oe_hdr
where datepart(yy,oe_ hdr.order_date) >= datepart(yy,get date()) - 2


-- ck

[KA NMC]

Thanks especially for the technet.

use datepart

something like:

select oe_hdr.customer _id
from oe_hdr
where datepart(yy,oe_ hdr.order_date) >= datepart(yy,get date()) - 2


-- ck