Getting the 'date' out of a DateTime field in SQL Server

Posted by thegunner on Stack Overflow See other posts from Stack Overflow or by thegunner
Published on 2010-04-13T12:39:14Z Indexed on 2010/04/13 12:52 UTC
Read the original article Hit count: 365

Filed under:
|
|

I have a date column where the date is displayed in the format 2009-11-18 10:55:28.370.

I just want to get the date (not time) out of that value. How do I do that?

© Stack Overflow or respective owner

Related posts about tsql

Related posts about sql-server