Extracting hours from a DateTime SQL Server 2005

Question

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

User · Answer

Use datepart   E g    datepart hh  date

User · Answer

select convert time GETDATE

User · Answer

I can t extract hours  with HOUR Date      There is a way to call HOUR  I would not recommend to use it though because there is DATEPART function  using ODBC Scalar Functions   SELECT  fn HOUR GETDATE     AS hour   LiveDemo

User · Answer

you can use it on any granularity type i e    DATEPART YEAR   date    DATEPART MONTH   date     DATEPART DAY   date        DATEPART HOUR   date     DATEPART MINUTE   date      note  I like the     around the date reserved word though  Of course that s in case your column with timestamp is labeled  date

User · Answer

DATEPART HOUR   date   returns the hour in military time   00 to 23   If you want 1AM  3PM etc  you need to case it out   SELECT Run Time Hour   CASE DATEPART HOUR  R date schedule      WHEN 0 THEN   12AM      WHEN 1 THEN    1AM      WHEN 2 THEN    2AM      WHEN 3 THEN    3AM      WHEN 4 THEN    4AM      WHEN 5 THEN    5AM      WHEN 6 THEN    6AM      WHEN 7 THEN    7AM      WHEN 8 THEN    8AM      WHEN 9 THEN    9AM      WHEN 10 THEN  10AM      WHEN 11 THEN  11AM      WHEN 12 THEN  12PM      ELSE CONVERT varchar  DATEPART HOUR  R date schedule -12     PM  END FROM     dbo ARCHIVE RUN SCHEDULE R

User · Answer

Try this one too   SELECT CONVERT CHAR 8  GETDATE   108

User · Answer

try this one too      DATEPART HOUR GETDATE

User · Answer

The DATEPART   function is used to return a single part of a date time  such as year  month  day  hour  minute  etc   datepart       Abbreviation  year           yy  yyyy  quarter        qq  q  month          mm  m  dayofyear      dy  y  day            dd  d  week           wk  ww  weekday        dw  w  hour           hh  minute         mi  n  second         ss  s  millisecond    ms  microsecond    mcs  nanosecond     ns    Example  select    from table001 where datepart hh datetime  like 23

User · Answer

SELECT DATEPART HOUR  GETDATE       DATEPART documentation

User · Answer

you must use datepart    like    datepart hour   getdate

User · Answer

select case when  am or  pm    PM  and datepart HOUR time received  lt  gt 12             then dateadd hour 12 time received              else time received         END  from table   works

[sql] Extracting hours from a DateTime (SQL Server 2005)

Examples related to sql

Examples related to tsql

Examples related to datetime

Examples related to sql-server-2005

Examples related to hour