SQL Server - Converting Integers into Date and Time Values in SQL Server

Converting Integers into Date and Time Values in SQL Server

Q

Can Integers Be Converted into Date and Time Values in SQL Server Transact-SQL?

✍: FYIcenter.com

A

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:

Integers can be converted to date and time values implicitly using assignment operations.
Integers can be converted to date and time values explicitly using CAST() or CONVERT() functions.

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

⇒⇒SQL Server Transact-SQL Tutorials

2017-02-22, 682👍, 0💬

Converting Date and Time Values into Integers in SQL Server
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time values be converted into integers? The answer is yes. The resulting integer will be the number days relative the base date: Jan 1, 1900. The time of the day will be rounded to days. But there several ru... 2017-02-22, 759👍, 0💬

Adding and Removing Days on Date and Time Values in SQL Server
How To Add or Remove Days on Date and Time Values in SQL Server Transact-SQL? SQL Server 2005 only support two operators on data and time values: + (Add): Adding days to a date and time value. - (Subtract): Removing days from a date and time value. Note that to add or subtract days on a date and tim... 2017-02-22, 696👍, 0💬

Converting Integers into Date and Time Values in SQL Server
Can Integers Be Converted into Date and Time Values in SQL Server Transact-SQL? 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 d... 2017-02-22, 683👍, 0💬

Subtracting a DATETIME Value from Another DATETIME Value in SQL Server
Can a DATETIME Value Be Subtracted from Another DATETIME Value in SQL Server Transact-SQL? Can a datetime value be subtracted from another datetime value? The answer is yes. The subtract operation can be performed by the subtract operator (-) as: datetime1 - datetime2: Returning a DATETIME value cal... 2017-02-20, 582👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.