DataTamer: SQL Server Services
Contact Us
Customer Site
Home
Services
Resources
Free!
About Us
Articles
Management Trees
Naming Conventions
Snippets
Date and Time
Documents
Design Specification
Release to Production
Useful Sites
SQL Server
Date and Time
/* SQL Snippets provided by: DataTamer Inc. Please feel free to use, edit or re-circulate as desired */ -- 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)
© All rights reserved. DataTamer Inc. 2010