Thursday, March 22, 2012

Comparing dates

Hello,

I am trying to retrieve the data that are not more than 3 months. How do I do this? The closest thing that I can do is...

(dbo.CLASSIFIEDADS.PostDate > CONVERT(DATETIME, '2006-03-26 00:00:00', 102))

I want to be able to put 3 months in there somehow...

Thanks in Advance!

check out the DATEDIFF function.|||FYI, it didn't exactly work out the way I wanted so I found another function, DATEADD with a minus number(-90) for days. Thanks for your help.

No comments:

Post a Comment