hi. i was wondering how i would set a time range so that the
DBatch.start field will display a range from 6PM yesterday or
tuesday(any weekday) to 5:59PM the next day i.e. today/wednesday.
Here's what i have:
SELECT DBatch.batchname, DBatch.start AS StartTime, DBatch.end,
DBatch.duration, DBatch.recordcount
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14000-query-time-range.html
FROM DBatch
WHERE ????
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14000
ORDER BY DBatch.start;
Both the DBatch.start and the DBatch.end fields are in the Date/Time
format.
Thanks.