DataTamer: SQL Server Services
Contact Us
Customer Site
Home
Services
Blog
Articles
Code
Downloads
About Us
Date and Time
A few snippets for converting date and time data.
-- Today's Date and Time PRINT GETDATE() -- Today's Date -- calculates the difference from the starting day to now in days, -- then adds it to the starting day, effectively truncating the time. PRINT DATEADD(DAY, DATEDIFF(DAY,0,GETDATE()), 0)
Code
Characters
Datatypes
Date & Time
Management Trees
© All rights reserved. DataTamer Inc. 2012