471,090 Members | 1,294 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,090 software developers and data experts.

mysql select help pleeeeease

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
Jul 20 '05 #1
2 1158
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.
Jul 20 '05 #2
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.

Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Gordon | last post: by
reply views Thread by Lenz Grimmer | last post: by
reply views Thread by Mike Chirico | last post: by
2 posts views Thread by Jeroen | last post: by
Atli
6 posts views Thread by Atli | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.