Post reply

Removing Time from Date

  • January 4, 2004 at 11:16 pm

    #488621

     Finally I found the formula I've forgotten: DateAdd(day,0,DateDiff(day,0,@DateVar))

    ...but I think using edwin_fredrick's way to cast it to varchar(11) is much more efficient ... as it's only one function call. Thanks edwin.

    Hendry

     

     

Viewing post 16 (of 15 total)

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