Collections:
Truncating DATETIME Values to Dates without Time in SQL Server
How To Truncate DATETIME Values to Dates without Time in SQL Server Transact-SQL?
✍: FYIcenter.com
Assuming that you have some date and time, DATETIME, values, and you want to work with dates only. You want to truncate them to dates without time, or with time of 00:00:00.000.
Again, SQL Server offers no simple solution, you need to write the formula yourself. The tutorial exercise below shows you how to do this with CONVERT() and FLOOR() functions:
-- truncating to dates DECLARE @local_time DATETIME; SET @local_time = 'May 19 2007 10:06PM'; SELECT 'Server local date and time: '; SELECT @local_time; SELECT 'Server local date without time: '; SELECT CONVERT(DATETIME, FLOOR(CONVERT(NUMERIC(18,9),@local_time))); GO Server local date and time: 2007-05-19 22:06:00.000 Server local date without time: 2007-05-19 00:00:00.000
Â
⇒Date/Time Operations and Functions in SQL Server Transact-SQL
2017-02-08, 1433👍, 0💬
Popular Posts:
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...