Time values and calculations

[RRinTetons]

SQL Server's datetime data type presents some challenges for me when the only part of it I want to deal with is the time. e.g. - I want to specify that a particular resource is available everyday from 9:00 AM to 4:00 PM. Now I want to check in an sp if it's currently later than 9 or earlier than 4. The only way I can see to do that is to always deal with the value through a bunch of function calls to strip it down to seconds since midnight (or something like that).

Is there a standard practice for dealing with times without dates on SQL Server?

-
Richard Ray
Jackson Hole Mountain Resort

 

[markros]

Yes, check

http://blog.sqlauthority.com/2007/12/23/sql-server-2008-new-datatypes-date-and-time/

and

http://www.sql-server-performance.com/articles/dev/date_time_search_p3.aspx

How To Check For A Certain Time With SQL

 

[markros]

Sorry, one more time the last link

How To Check For A Certain Time With SQL