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, 1511🔥, 0💬
Popular Posts:
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...