query time

[Guest]

I have a field that contains the arrival date of a customer.
It is formatted as a long date.

I need to be able to create a query that pulls all the times for each hour.
For example, I want to be able to query all the arrivals from 7:00 am to
7:59 am, but can not use the between command.

Can you help?

 

[Guest]

Try..
Select * from Yourtable where datepart('h',YourDateField) = 7