Extracting hours from a DateTime (SQL Server 2005)

by 
SELECT DATEPART(HOUR, GETDATE());

DATEPART documentation

More Related Contents:

  1. SQL query to select dates between two dates
  2. Is it possible to write single query on two table which are not connected to each other?
  3. Get top 1 row of each group
  4. How to return only the Date from a SQL Server DateTime datatype
  5. SQL update query using joins
  6. How to update two tables in one statement in SQL Server 2005?
  7. Referring to a Column Alias in a WHERE Clause
  8. DateTime2 vs DateTime in SQL Server
  9. Convert Month Number to Month Name Function in SQL
  10. Create a date from day month and year with T-SQL
  11. Selecting COUNT(*) with DISTINCT
  12. Generate a resultset of incrementing dates in TSQL
  13. Getting result of dynamic SQL into a variable for sql-server
  14. How to get difference between two rows for a column field?
  15. Better techniques for trimming leading zeros in SQL Server?
  16. SQL – Subtracting a depleting value from rows
  17. How to print VARCHAR(MAX) using Print Statement?
  18. What’s the best way to select the minimum value from several columns?
  19. SELECT FOR UPDATE with SQL Server
  20. Easiest way to populate a temp table with dates between and including 2 date parameters
  21. How can I determine the status of a job?
  22. SQL Server 2005 ROW_NUMBER() without ORDER BY
  23. Can an INNER JOIN offer better performance than EXISTS
  24. Getting Dates between a range of dates
  25. Cumulative Total in MS Sql server [duplicate]
  26. What does collation mean?
  27. Memory effective way to read BLOB data in C#/SQL 2005
  28. Distributed transaction error?
  29. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?
  30. Determine what user created objects in SQL Server

Leave a Comment