SQL Server - Time-Only DATETIME Values in SQL Server Transact-SQL

Time-Only DATETIME Values in SQL Server Transact-SQL

Q

What Happens If Time-Only Values Are Provided for DATETIME variables in SQL Server Transact-SQL?

✍: FYIcenter.com

A

If only time value is provided in a DATETIME variable, the SQL Server will pad the date value with a zero, representing the base date, January 1, 1900. The tutorial exercise below gives you some good examples:

-- 'hh:mi:ss.mmm' format
DECLARE @x DATETIME;
SET @x = '22:55:07.233';
SELECT @x;
-----------------------
1900-01-01 22:55:07.233

-- 'hh:mi:ss.mmmAM/PM' format
DECLARE @x DATETIME;
SET @x = '10:55:07.233PM';
SELECT @x;
-----------------------
1900-01-01 22:55:07.233

-- 'hh:miAM/PM' format
DECLARE @x DATETIME;
SET @x = '10:55PM';
SELECT @x;
-----------------------
1900-01-01 22:55:00.000

⇒Variables and Data Types in SQL Server Transact-SQL

⇒⇒SQL Server Transact-SQL Tutorials

2017-04-08, 726👍, 0💬

Single-Byte Character Data Types in SQL Server Transact-SQL
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte character string data types are used to hold single-byte character strings. There are 3 single-byte character string data types supported in SQL Server Transact-SQL: 1. CHAR (or CHARACTER) - Used to ho... 2017-04-08, 922👍, 0💬

Out-of-Range DATETIME Values in SQL Server Transact-SQL
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIME values, you may get out-of-range errors due to two common mistakes: The date value is a valid calendar date, but it is not in the range covered by DATETIME data type: from January 1, 1753, to Decemb... 2017-04-08, 730👍, 0💬

Time-Only DATETIME Values in SQL Server Transact-SQL
What Happens If Time-Only Values Are Provided for DATETIME variables in SQL Server Transact-SQL? If only time value is provided in a DATETIME variable, the SQL Server will pad the date value with a zero, representing the base date, January 1, 1900. The tutorial exercise below gives you some good exa... 2017-04-08, 727👍, 0💬

Date-Only DATETIME Values in SQL Server Transact-SQL
What Happens If Date-Only Values Are Provided for DATETIME in SQL Server Transact-SQL? If only date value is provided in a DATETIME variable, the SQL Server will pad the time value with a zero, or '00:00:00.000', representing the midnight time of the day. The tutorial exercise below gives you some g... 2017-04-08, 643👍, 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.