Searching a datetime field by time

[Andrew Chalk]

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.

[Eric J. Holtman]

"Andrew Chalk" <ac****@magnacartasoftware.com> wrote in
news:Pg***************@newssvr11.news.prodigy.com:

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.

Scary. Really scary.
select * from Events
where datpart(hh,evt_time) between 11 and 13

[Andrew Chalk]

Thanks.
"Eric J. Holtman" <ej*@ericholtman.com> wrote in message
news:Xn*******************************@216.168.3.3 0...

"Andrew Chalk" <ac****@magnacartasoftware.com> wrote in
news:Pg***************@newssvr11.news.prodigy.com:

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.

Scary. Really scary.
select * from Events
where datpart(hh,evt_time) between 11 and 13

[Eric J. Holtman]

"Andrew Chalk" <ac****@magnacartasoftware.com> wrote in news:u1Bxf.210$F_
3.**@newssvr29.news.prodigy.net:

I screwed it up. If you really want everything between 11 and 1,
you want
select * from Events
where datpart(hh,evt_time) between 11 and 12