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, 1475🔥, 0💬
Popular Posts:
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...