Home Forums Programming General DATETIME: just date and concate time RE: DATETIME: just date and concate time

  • July 31, 2003 at 11:16 am

    #468058

    Lots of ways to strip the time. Here is how I would do

    DATEADD(hh,5,DATEADD(d,DATEDIFF(d,0,GETDATE()),0))