Hello,

I'm somewhat of a newbie to SQL and am stumped on how to perform a particular
datetime query. I'm trying to query a Datetime column by a specific date
and then by a specific time range (ex. 06:00:00-10:00:00).

With the following code I'm able to narrow down a date range, however this
does not bring back a specific time range. Any thoughts on how I can search
a datetime column using a specific time range? Any help would be appreciated.

Here's the code I've been using to query by date range:

SELECT HX_EVENTS.EVENTID, HX_EVENTS.OBJECTNAME, HX_ENTRIES.EVENTTIME, HX_AUXDATA.ITEMDATA
FROM NT3400.dbo.HX_AUXDATA HX_AUXDATA, NT3400.dbo.HX_ENTRIES HX_ENTRIES,
NT3400.dbo.HX_EVENTS HX_EVENTS
WHERE HX_AUXDATA.ENTRYID = HX_ENTRIES.ENTRYID AND HX_AUXDATA.ENTRYID = HX_EVENTS.ENTRYID
AND HX_AUXDATA.OBJSITE = HX_ENTRIES.OBJSITE AND HX_AUXDATA.OBJSITE = HX_EVENTS.OBJSITE
AND HX_ENTRIES.ENTRYID = HX_EVENTS.ENTRYID AND HX_ENTRIES.OBJSITE = HX_EVENTS.OBJSITE
AND ((HX_ENTRIES.EVENTTIME>={ts '2002-10-28 23:33:31'} And HX_ENTRIES.EVENTTIME<={ts
'2002-11-05 19:55:24'}) AND (HX_AUXDATA.ITEMDATA='LAB Cafe Cashier #1'))