Collections:
Casting Numeric Values to DATETIME in SQL Server Transact-SQL
Can I cast numeric values to DATETIME values in SQL Server Transact-SQL?
✍: FYIcenter.com
Yes, you can cast numeric values to DATATIME values in Transact-SQL. The implicit casting rules are for numeric values to DATETIME values are:
Here are some examples of casting numeric values to DATETIME values implicitly:
DECLARE @x DATETIME; SET @x = 0; SELECT @x; ----------------------- 1900-01-01 00:00:00.000 DECLARE @x DATETIME; SET @x = 1; SELECT @x; ----------------------- 1900-01-02 00:00:00.000 DECLARE @x DATETIME; SET @x = 0.1; SELECT @x ----------------------- 1900-01-01 02:24:00.000 DECLARE @x DATETIME; SET @x = -1; SELECT @x; ----------------------- 1899-12-31 00:00:00.000
⇒ Entering 0.001 Second in DATETIME in SQL Server Transact-SQL
⇐ Entering Date and Time Values in SQL Server
2017-04-15, 1554🔥, 0💬
Popular Posts:
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...