Extracting hours from a DateTime (SQL Server 2005)

Admin 1
Viewed 717100

I can extract the month and day by using Day(Date()), Month(Date()). I can't extract hours, with HOUR(Date()). I get the following error.

'HOUR' is not a recognized built-in function name.

How can I extract hours?

hour sql-server-2005 datetime tsql sql
12 Answers
Dave_M_249950

Use datepart.

E.g.:

datepart(hh, date)
user_832470

Try this one too:

SELECT CONVERT(CHAR(8),GETDATE(),108)
user_127720870

To include AM / PM - use the below:

SELECT 
  concat(case when datepart(hour,getdate()) % 12 = 0 then 12 
              else datepart(hour,getdate()) % 12 end,
         case when datepart(hour,getdate()) < 12 then ' AM' 
              else ' PM' end
        )
user_125319360 
select convert(time,GETDATE())
user_36397200
Related