Home Forums SQL Server 2005 Business Intelligence DateAdd() - how to add 5 hours and 25 minutes to a date? RE: DateAdd() - how to add 5 hours and 25 minutes to a date?

  • August 9, 2013 at 12:54 pm

    #1640248

    This also works:

    select

    Curr_Datetime= getdate(),

    [Curr_Datetime Plus 05:25] =getdate()+'05:25:00.000'

    Results:

    Curr_Datetime Curr_Datetime Plus 05:25

    ----------------------- ------------------------

    2013-08-09 14:52:58.457 2013-08-09 20:17:58.457