Truncate Datetime to Second (Remove Milliseconds) in T-SQL

by

This will truncate the milliseconds.

declare @X datetime
set @X = '2012-01-25 17:24:05.784'
select convert(datetime, convert(char(19), @X, 126))

or

select dateadd(millisecond, -datepart(millisecond, @X), @X)

CAST and CONVERT
DATEADD
DATEPART

More Related Contents:

  1. How to convert Seconds to HH:MM:SS using T-SQL
  2. How to convert a “dd/mm/yyyy” string to datetime in SQL Server?
  3. SQl CASE Statement
  4. SQL query to select dates between two dates
  5. How to get sp_executesql result into a variable?
  6. How can I select the first day of a month in SQL?
  7. How can I convert bigint (UNIX timestamp) to datetime in SQL Server?
  8. How can I use optional parameters in a T-SQL stored procedure?
  9. How to get Time from DateTime format in SQL?
  10. T-SQL Decimal Division Accuracy
  11. Selecting a Record With MAX Value
  12. What is a “batch”, and why is GO used?
  13. TSQL divide by zero encountered despite no columns containing 0
  14. T-SQL loop over query results
  15. How to insert default values in SQL table?
  16. How to Round a Time in T-SQL
  17. Return a value if no rows are found in Microsoft tSQL
  18. Extracting hours from a DateTime (SQL Server 2005)
  19. Check if a varchar is a number (TSQL)
  20. Using Aliases in Where Clause or an Alternative Option?
  21. Extract the first word of a string in a SQL Server query
  22. Can I use the MERGE statement in SQL Server 2005?
  23. How to compare datetime with only date in SQL Server
  24. Search for one value in any column of any table inside a database
  25. Check if a varchar is a number (T-SQL)
  26. Using a cursor with dynamic SQL in a stored procedure
  27. Convert unix epoch timestamp to TSQL datetime
  28. String.Format like functionality in T-SQL?
  29. How to parse string into date?
  30. How to calculate difference in hours (decimal) between two dates in SQL Server?

Leave a Comment