Skip to Content
Former Member
Jan 12, 2006 at 12:19 AM

Date and Time problem


I have this query where you have to get all the data from a certain date and ranges of time. For example.


Date: 01.01.06 - 01.02.06

Time ranges: 07:00:00 - 23:59:59

00:00:00 - 07:00:00

The problem is that I'm getting the data of 00:00:00-07:00:00 for the first date and data from 07:00:00-23:59:59 of the second date.

I just want to query the data from 7am to 7am of the following date.

Thanks for any help you may give.