How to get date of 234 days back in SQL?

Posted by Bhakti on 11/24/2009 | Category: Sql Server Interview questions | Views: 7158

Answer:

SQL :
SELECT DATEADD(dd,-234,getdate())

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What is SIGN() ?

Next > : Write and justify output of - select nullif('test' ...

Posted by: Lakhangarg on: 11/26/2009

HI-

You can use this too:
SELECT GETDATE()-234

Thanks & Regards
Lakhan Pal Garg

More Interview Questions by Bhakti

Latest Interview Questions