How can I group time by hour or by 10 minutes?

by

finally done with

GROUP BY
DATEPART(YEAR, DT.[Date]),
DATEPART(MONTH, DT.[Date]),
DATEPART(DAY, DT.[Date]),
DATEPART(HOUR, DT.[Date]),
(DATEPART(MINUTE, DT.[Date]) / 10)

More Related Contents:

  1. How to group time by hour or by 10 minutes
  2. Is it possible to write single query on two table which are not connected to each other?
  3. T-SQL split string
  4. How can I get column names from a table in SQL Server?
  5. Conditional WHERE clause in SQL Server
  6. How can I select the first day of a month in SQL?
  7. Is the NOLOCK (Sql Server hint) bad practice?
  8. Multi-statement Table Valued Function vs Inline Table Valued Function
  9. Remove trailing zeros from decimal in SQL Server
  10. GROUP BY to combine/concat a column [duplicate]
  11. Select statement to find duplicates on certain fields
  12. Parse comma-separated string to make IN List of strings in the Where clause
  13. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  14. Compare DATETIME and DATE ignoring time portion
  15. How to create a PivotTable in Transact/SQL?
  16. Split function in SQL Server 2008
  17. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  18. How to efficiently delete rows while NOT using Truncate Table in a 500,000+ rows table
  19. T-SQL and the WHERE LIKE %Parameter% clause
  20. sql group by only rows which are in sequence
  21. Generate all combinations in SQL
  22. How can I group by date time column without taking time into consideration
  23. How to return a incremental group number per group in SQL
  24. When using GETDATE() in many places, is it better to use a variable?
  25. Cumulative Total in MS Sql server [duplicate]
  26. SQL Server SELECT INTO @variable?
  27. Flattening of a 1 row table into a key-value pair table
  28. SQL Server equivalent of WM_CONCAT function [duplicate]
  29. SQL Server: +(unary) operator on non-numeric Strings
  30. How to do a case sensitive GROUP BY?

Leave a Comment