This entry was posted on Monday, May 23rd, 2005 at 11:50 am and is filed under Uncategorized, Tech data. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.
Use:
CONVERT(datetime, CONVERT(char(10), GETDATE(), 101))
to strip the time from a datetime field.