Sawaf's food for thought...
Documenting Experience!
Monday, 15 April 2013
Print Date and Time Using TSQL
PRINT LEFT(REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR, GETDATE(), 121), '-','_'),':','_'),' ','_'), 16)
16 characters on the LEFT only to omit extra time details.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment