Find previous 25 th month

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Suresh B. SSC-Insane Points: 22986 More actions · Answer 1

Use DATEADD function. For example:

select getdate(), dateadd(m, -25, getdate())

2008-06-23 10:03:11.3172006-05-23 10:03:11.317

marees.inspire Ten Centuries Points: 1324 More actions · Answer 2

Ten Centuries

Points: 1324

June 22, 2008 at 10:46 pm

Thanks Suresh for you valuable reply..........:)

Cookies on SQLServerCentral