Posted by ZeldorBlat on 11/18/05 04:49

>Here's a safer way to trim the time from a date while still getting a
>datetime result:
>
>DATEADD(day, DATEDIFF(day, '20000101', someDate), '20000101')

Point taken. I like that one, too.

[Back to original message]