Collections:
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?
✍: FYIcenter.com
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
⇒ Out-of-Range DATETIME Values in SQL Server Transact-SQL
⇐ Date-Only DATETIME Values in SQL Server Transact-SQL
2017-04-08, 1552🔥, 0💬
Popular Posts:
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...