locked
SELECT DATEADD(day, -1, getdate()) .. need it for elaborate specific usage RRS feed

  • Question

  •  

    SELECT DATEADD(day, -1, getdate())

    i am getting output as : 

    2008-06-17 11:42:06.140


    the time and date now is:  2008-06-18 11:42:06.140

    i just need to get  20080617 as the output without any time .. how do i do it ...??

    Wednesday, June 18, 2008 5:29 PM

Answers

All replies