What is time_offset in MSSQL?

Hi, I'm trying to decipher some code that selects tasks based on their time, or so it says... Here's the filter:

datepart(hh,@NOW)*60 + datepart(mi,@NOW) + time_offset*60 BETWEEN 480 and 1170)

A comment next to it says it will select tasks between 8:00 am and 7:30 pm. Is this correct? How does this work?
horaliaAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
cyberkiwiConnect With a Mentor Commented:
[b]time_offset[/b] is a column in some table that is part of that select...

It is the number of hours by which to shift the range 8:00 to [b]19[/b]:30 by. So if it is 1.5, the range becomes 9:30am - 9pm
0
 
cyberkiwiCommented:
[b]time_offset[/b] is a column in some table that is part of that select...

It is most likely an integer value (number) that represents how many minutes to shift the range 8:00 to 17:30 by.
0
 
horaliaAuthor Commented:
Don't even know the tables I'm working with... thought it was some type of function! Thanks!
0
All Courses

From novice to tech pro — start learning today.