[dba-SQLServer] RE: Just Date

David Lewis DavidL at sierranevada.com
Thu May 19 13:24:24 CDT 2005




I find the following works well:

CONVERT(DATETIME,(CONVERT(varchar,TheDateField,112)))

This strips off the time portion and returns the date.  I have never
perceived any performance hits, but I also haven't done any rigorous
comparisons.

HTH  D. Lewis




More information about the dba-SQLServer mailing list