How to capture only the hour from the particular datetime in sql

• jprabha.d

  Ten Centuries

  Points: 1086

  More actions

  December 8, 2009 at 6:02 am

  #137415

  Hi ,

  I want to get the only the "hour" for the particular datetime ,

  For example :

  If we write ---select year(getdate()) --it gives you the result say -2009 as year ,

  in the same way i want to get the "hour "

  what is the Function used to get the hour from the getdate() .

  thanks in advanced

  jaya

• Dave Ballantyne

  SSC-Dedicated

  Points: 33566

  More actions

  December 8, 2009 at 6:12 am

  #1089154

  lookup "datepart" in BOL

  ---

  
  Clear Sky SQL
  My Blog[/url]

• matt6288

  SSCertifiable

  Points: 5058

  More actions

  December 8, 2009 at 6:13 am

  #1089156

  Try this:

  SELECT DATEPART(hh,GETDATE())