Posted by Eric J. Holtman on 01/14/06 01:37

"Andrew Chalk" <achalk@magnacartasoftware.com> wrote in news:u1Bxf.210$F_
3.61@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

• Next in forum: Re: Why would adding dbo. cause my function to run forever?
• Prev in forum: Re: Deadlocks, why?
• Thread view: Re: Searching a datetime field by time

[Reply to this message]