sql solace
Monday, 3 December 2007
Datetime manipulation Gotcha
Spot the difference -
SELECT CONVERT(DATETIME,'2007-12-03 11:51:00.000',21)
2007-12-03 11:51:00.000
PRINT CONVERT(DATETIME,'2007-12-03 11:51:00.000',21)
Dec 3 2007 11:51AM
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment