Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO MyTable(DateField) VALUES('20090430')
- SELECT CONVERT(VARCHAR, DateField, 126) FROM MyTable
- 2009-04-30T00:00:00.000
- SELECT CONVERT(NVARCHAR(30), GETDATE(), 126)
- 2009-05-01T14:18:12.430
Add Comment
Please, Sign In to add comment