Collections:
Entering Date and Time Values in SQL Server
How To Enter Date and Time values in SQL Server Transact-SQL?
✍: FYIcenter.com
Transact-SQL does not support date and time literals. If you want to enter date and time values, you have to use character string literals and rely implicit casting rules to convert them into date and time values.
When casting character string literals into DATETIME values, you can use one of these recognizable data and time formats shown below:
-- Default format for query output DECLARE @x DATETIME; SET @x = '2017-05-19 22:55:07.233'; SELECT @x; ---------------------------- 2017-05-19 22:55:07.233 -- Default for string print output DECLARE @x DATETIME; SET @x = 'May 19 2017 10:55PM'; SELECT @x; ---------------------------- 2017-05-19 22:55:00.000 -- Europe default format DECLARE @x DATETIME; SET @x = '19-May-2017 22:55:07.233'; SELECT @x; ---------------------------- 2017-05-19 22:55:07.233 -- ISO8601 standard format DECLARE @x DATETIME; SET @x = '2017-05-19T22:55:07.233'; SELECT @x; ---------------------------- 2017-05-19 22:55:07.233
⇒ Casting Numeric Values to DATETIME in SQL Server Transact-SQL
⇐ Date and Time Data Types in SQL Server Transact-SQL
2017-04-15, 1430🔥, 0💬
Popular Posts:
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...