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
Â
⇒Date/Time Operations and Functions in SQL Server Transact-SQL
2017-02-22, 1458👍, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Recreate an Existing Index in SQL Server? If you want to change the definition of an existing...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Replace NULL Values in Expressions using ISNULL() in SQL Server Transact-SQL? As you learned ...