Home Forums SQL Server 2008 T-SQL (SS2K8) set date/time to today date but certain time RE: set date/time to today date but certain time

  • October 11, 2013 at 8:56 am

    #1657943

    This should do it:

    select TodayAt4am = dateadd(dd,datediff(dd,0,getdate()),'04:00:00')

    Results:

    TodayAt4am

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

    2013-10-11 04:00:00.000