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
2017-04-15, 733👍, 0💬
Popular Posts:
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
What is Microsoft SQL Server in SQL Server? Microsoft SQL Server is a relational database management...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...