A way to extract from a DateTime value data without seconds

by 
SELECT DATEADD(MINUTE, DATEDIFF(MINUTE, 0, yourcolumn), 0) FROM yourtable

This will be effective, if you don’t want a slow conversion between datatypes.

More Related Contents:

  1. Convert text to system date format [duplicate]
  2. How to return only the Date from a SQL Server DateTime datatype
  3. Best approach to remove time part of datetime in SQL Server
  4. DateTime2 vs DateTime in SQL Server
  5. SQL query to select dates between two dates
  6. How to combine date from one field with time from another field – MS SQL Server
  7. How can I select the first day of a month in SQL?
  8. How can I convert bigint (UNIX timestamp) to datetime in SQL Server?
  9. How to convert DateTime to VarChar
  10. Get day of week in SQL Server 2005/2008
  11. T-SQL: Round to nearest 15 minute interval
  12. SQL Server Convert Varchar to Datetime
  13. How Can I use “Date” Datatype in sql server?
  14. How to determine the number of days in a month in SQL Server?
  15. Calculate business hours between two dates
  16. SQL Server convert string to datetime
  17. How do I query for all dates greater than a certain date in SQL Server?
  18. How can I compare time in SQL Server?
  19. Difference of two date time in sql server
  20. Custom Date/Time formatting in SQL Server
  21. How to compare datetime with only date in SQL Server
  22. Getting Dates between a range of dates
  23. How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
  24. What is the internal representation of datetime in sql server?
  25. SQL SERVER DATETIME FORMAT
  26. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  27. Getting the Id of a row I updated in Sql Server
  28. Backup a single table with its data from a database in sql server 2008
  29. What is the meaning of SELECT … FOR XML PATH(‘ ‘),1,1)?
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment