mysql select help pleeeeease

[Jeroen]

Hello,

I want to select from a date field records with 1 hour interval.
I tried many things but without any luck..

Any suggestions ?

Jeroen

[Bill Karwin]

Jeroen wrote:

I want to select from a date field records with 1 hour interval.
I tried many things but without any luck..

For example, this query should return records where the time is between
9:00am and 9:59am.

select *
from myTable
where extract(hour from myDateTimeColumn) = 9;

Regards,
Bill K.

[Jeroen]

Thanx very much this helped me on my solution !!
"Bill Karwin" <bi**@karwin.com> wrote in message
news:cf*********@enews3.newsguy.com...

Jeroen wrote:

I want to select from a date field records with 1 hour interval.
I tried many things but without any luck..

For example, this query should return records where the time is between
9:00am and 9:59am.

select *
from myTable
where extract(hour from myDateTimeColumn) = 9;

Regards,
Bill K.