[dba-SQLServer] Getting rid of time in result set

John W. Colby jwcolby at colbyconsulting.com
Wed Oct 27 21:51:04 CDT 2004


How do I get rid of the time in a date column in the result set?

2005-01-02 00:00:00.000

Should be

2005-01-02

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/





More information about the dba-SQLServer mailing list