Post reply

DateTime function

  • May 7, 2009 at 11:26 am

    #132127

    Hi...How can I get the Same day of Last year?? please give me the sql query...

    Thank you

  • May 7, 2009 at 11:28 am

    #990555

    ssismaddy (5/7/2009)

    Hi...How can I get the Same day of Last year?? please give me the sql query...

    Thank you

    And what have you tried? Have you looked in BOL regarding datetime functions?

  • May 7, 2009 at 11:34 am

    #990560

    thanks for the response... I m trying weird commands like select getdate()-1 or year(getdate())-1)...

    still I m trying to search BOL....if you could help me thats gr8 for me...

  • May 7, 2009 at 11:42 am

    #990572

    got it ...

    select dateadd(year, -1, getdate())

    Thank you

  • May 7, 2009 at 11:43 am

    #990574

    Glad to see that.

Viewing 5 posts - 1 through 4 (of 4 total)

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