Posted by ZeldorBlat on 11/18/05 00:52

If you wanto remove the time portion and keep the value as datetime
(instead of char) you can use this:

CAST(FLOOR(CAST(someDate AS float)) AS datetime)

I always thought that was a nifty idiom -- but I'm not sure of the
performance implications (if any).

• Next in forum: Make a Bunch of Rows from a Table Resemble a Column
• Prev in forum: Re: Simple SQL Query (To Neglect time from DateTime DataType)
• Thread view: Re: Simple SQL Query (To Neglect time from DateTime DataType)

[Reply to this message]