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
⇒ Converting DATETIME and NUMERIC Values in SQL Server
⇐ Converting Date and Time Values into Integers in SQL Server
⇑ Date/Time Operations and Functions in SQL Server Transact-SQL
2017-02-22, 1488🔥, 0💬
Popular Posts:
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...