SQL Server FAQs - Transact-SQL Date and Time Operations and Functions http://dba.fyicenter.com/faq/sql_server/Transact-SQL_Date_and_Operations_and_Functions.html A collection of 18 FAQs on Transact-SQL language date and time operations and functions. Clear answers are provided with tutorial exercises on converting date and time values to integers or decimal values; incrementing and decrementing date parts; taking date differences; formatting dates to strings; getting GMT times. Please visit this Website.: http://dba.fyicenter.com/faq/sql_server/Transact-SQL_Date_and_Operations_and_Functions.html TThank you, Team DBAFYI - DBA Resource Center http://dba.fyicenter.com