Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

What is time_offset in MSSQL?

Posted on 2010-11-22
3
Medium Priority
?
433 Views
Last Modified: 2012-06-27
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?
0
Comment
Question by:horalia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 58

Expert Comment

by:cyberkiwi
ID: 34193279
[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
 
LVL 58

Accepted Solution

by:
cyberkiwi earned 2000 total points
ID: 34193281
[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
 

Author Closing Comment

by:horalia
ID: 34193367
Don't even know the tables I'm working with... thought it was some type of function! Thanks!
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

596 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question