?
Solved

SQL Criterion, What does it mean?

Posted on 2009-03-30
2
Medium Priority
?
844 Views
Last Modified: 2012-05-06
The following criterion is used in a query from an application that I have inherited.  It is on a table field 'CollTime' that is specified as Date/Time with no other format.  The contents of the field look like '2:50:00 PM', '11:45:00 AM' etc..

>=([CollectTime]-0.010416667) And <=([CollectTime]+0.010416667)
0
Comment
Question by:mlcktmguy
[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 Comments
 
LVL 93

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 24021695
0.010416667 works out to ~900 seconds, or 15 minutes.

There are 86,400 seconds in one day, 0.010416667 * 86400 = 900

So it seems that one time is being checked to see if it is +/1 15 minutes from another time.
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24021761
datetime is calculated like this:

1 = 1 day = 24 hours.

so, 0.01041667 +- 0.25 hours = 15 minutes.
0

Featured Post

Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

800 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