Collections:
Date-Only DATETIME Values in SQL Server Transact-SQL
What Happens If Date-Only Values Are Provided for DATETIME in SQL Server Transact-SQL?
✍: FYIcenter.com
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 good examples:
-- 'mm/dd/yyyy' format DECLARE @x DATETIME; SET @x = '05/19/2017'; SELECT @x; ----------------------- 2017-05-19 00:00:00.000 -- 'mm.dd.yy' format DECLARE @x DATETIME; SET @x = '05.19.07'; SELECT @x; ----------------------- 2017-05-19 00:00:00.000 -- 'yyyy-mm-dd' format DECLARE @x DATETIME; SET @x = '2017-05-19'; SELECT @x; ----------------------- 2017-05-19 00:00:00.000 -- 'mon dd, yyyy' format DECLARE @x DATETIME; SET @x = 'May 19, 2017'; SELECT @x; ----------------------- 2017-05-19 00:00:00.000 -- 'dd-mon-yyyy' format DECLARE @x DATETIME; SET @x = '19-May-2017'; SELECT @x; ----------------------- 2017-05-19 00:00:00.000
⇒ Time-Only DATETIME Values in SQL Server Transact-SQL
⇐ Entering 0.001 Second in DATETIME in SQL Server Transact-SQL
2017-04-08, 3310🔥, 0💬
Popular Posts:
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...