Posted by Andrew Chalk on 01/12/06 21:40

I have the time of an event stored on each record as a datetime field.It
includes the year,month,day, etc. Suppose my user wants to search the table
for all events over the lunch hour, say between11am and 1pm. How do I
construct the SELECT query to peek into each datetime field and return only
those records that satify the specified time range?

Many thanks.

• Next in forum: Re: Searching for a partial match in a varchar field
• Prev in forum: Searching for a partial match in a varchar field
• Thread view: Searching a datetime field by time

[Reply to this message]