datetime to date

[sbcsandhu]

my date is a datetime field. what is the function i would use to change it to only a date

 

[kaht]

I assume you mean that you would want a datetime field w/o the time precision - i.e. a date that started at 00:00.000?

select convert(datetime, datediff(dd, 0, getdate()))

-kaht

Lisa, if you don't like your job you don't strike. You just go in every day and do it really half-assed. That's the American way. - Homer Simpson
[small]<P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <.</B> bites again.[/small]

 

[gmmastros]

There's no such thing as a date data type. There is always a time component. Sorry.


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[AlexCuse]

I think there is in SQL Server 2008 ;-)

[small]----signature below----[/small]
Now you can go where the people are one!
Now you can go where they get things done!

 

[gmmastros]

So... sometime in the future, my answer will be wrong.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom