"hour" function?

• Russ-230211

  SSC Veteran

  Points: 293

  More actions

  October 4, 2005 at 4:28 pm

  #89189

  I am continually amazed at the lack of functions within TSQL.  I like the product, but you would have thought that at this day and age of computer programming, the writers of TSQL would have put more functions in their product.

  They have a datatype which holds date and time, yet there is no function to easily separate out the two.  There is a day, month, and year function to work on datetime, but no time functions.

  so, my question is, after all this ranting, is there some special function somewhere to extract out the time, like "hour(getdate())"?, or do I need to use the convert/cast functions to edit out the hour?

  Thanks for any and all help.

  Russ....

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  October 4, 2005 at 4:34 pm

  #595027

  have you looked at datepart()?

  select datepart(hh,getdate())

  DATEPART

  Returns an integer representing the specified datepart of the specified date.

  Syntax

  DATEPART ( datepart , date )

  Arguments

  datepart

  Is the parameter that specifies the part of the date to return. The table lists dateparts and abbreviations recognized by Microsoft® SQL Server™.

  Datepart	Abbreviations
  year	yy, yyyy
  quarter	qq, q
  month	mm, m
  dayofyear	dy, y
  day	dd, d
  week	wk, ww
  weekday	dw
  hour	hh
  minute	mi, n
  second	ss, s
  millisecond	ms

• Russ-230211

  SSC Veteran

  Points: 293

  More actions

  October 4, 2005 at 4:37 pm

  #595028

  I feel like an idiot and I must be going blind.

   

  Thanks

  Russ...

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  October 4, 2005 at 4:45 pm

  #595030

  If your not going blind, then your not doing it right.