convert Datetime to Date without using varchar or char

[fredong]

Hi,
Is there a way to convert Datetime to Date without using varchar or char? This is because the date will be using for calculation later. Thanks.

 

[gmmastros]

You cannot convert to Date (only), but you can remove the time component. The time component will still be there, but the following code will set it to midnight.

[tt][blue]Select DateAdd(Day, DateDiff(Day, 0, GetDate()), 0)[/blue][/tt]

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom