Greetings,
I have a db where Im pulling data with Between date1 and date2.
example:
date1 = 5/17/10 6:00 AM
date2 = 7/16/10 3:30 PM
the query pulls everything like it should, but I need to exclude anything that is "after hours".
The data that Im looking for would be like the following:
5/17/10 6:00 AM to 3:30 PM
5/18/10 6:00 AM to 3:30 PM
.
.
7/16/10 6:00 AM to 3:30 PM
Is there a way to do this without having to querey each date with the specific times?