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.

• Next in forum: Re: need a DBA Suggestion.
• Prev in forum: Re: need help
• Thread view: Re: Simple SQL Query (To Neglect time from DateTime DataType)

[Reply to this message]