Collections:
Converting Integers into Date and Time Values in SQL Server
Can Integers Be Converted into Date and Time Values in SQL Server Transact-SQL?
✍: FYIcenter.com
Can integers be converted into date and time values? The answer is yes. The input integer will be used as the number of days relative to the base date: Jan 1, 1900. The time of the day will be set to 0, midnight of the day. But there several rules you need to follow:
Here are some good examples:
-- Explicit conversion is supported DECLARE @birth_date DATETIME; SET @birth_date = CONVERT(DATETIME, 36583); SELECT @birth_date; GO 2000-02-29 00:00:00.000 -- Explicit conversion is supported DECLARE @birth_date DATETIME; SET @birth_date = CONVERT(DATETIME, 36583); SELECT @birth_date; GO 2000-02-29 00:00:00.000
Â
⇒Date/Time Operations and Functions in SQL Server Transact-SQL
2017-02-22, 1270👍, 0💬
Popular Posts:
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...