Collections:
Converting DATETIME and NUMERIC Values in SQL Server
Are DATETIME and NUMERIC Values Convertible in SQL Server Transact-SQL?
✍: FYIcenter.com
Are datetime and numeric value convertible? The answer is yes. Here are the main rules on DATATIME and NUMERIC value conversions:
The tutorial exercise below shows you some good examples:
-- Implicit conversion NUMERIC to DATETIME DECLARE @birth_date DATETIME; SET @birth_date = 36583.25; SELECT @birth_date; GO 2000-02-29 06:00:00.000 -- Explicit conversion NUMERIC to DATETIME DECLARE @birth_date DATETIME; SET @birth_date = CONVERT(DATETIME, 36583.75); SELECT @birth_date; GO 2000-02-29 18:00:00.000 -- Implicit conversion DATETIME to NUMERIC DECLARE @birth_date DATETIME; DECLARE @birth_days NUMERIC(9,2); SET @birth_date = '2000-02-29 06:00:00.000'; SET @birth_days = @birth_date; GO Msg 257, Level 16, State 3, Line 4 Implicit conversion from data type datetime to numeric is not allowed. Use the CONVERT function to run this query. -- Explicit conversion DATETIME to NUMERIC DECLARE @birth_date DATETIME; DECLARE @birth_days NUMERIC(9,2); SET @birth_date = '2000-02-29 18:00:00.000'; SET @birth_days = CONVERT(NUMERIC(9,2), @birth_date); SELECT @birth_days; GO 36583.75
⇒ Subtracting a DATETIME Value from Another DATETIME Value in SQL Server
⇐ Converting Integers into Date and Time Values in SQL Server
⇑ Date/Time Operations and Functions in SQL Server Transact-SQL
2017-02-22, 1775🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...