Actually, i have a table name district_data where the fields are district_id,Temperature, Rainfall,Wind, Date and Time.

district_id Temperature Rainfall Wind Date Time

1 17.5 5.0 8.0 2011-03-09 10:00:00

1 18.5 6.0 7.0 2011-03-09 11:00:00

It means the table contains the datas for every 1 hour interval. i must fetch the current time datas. I must have the value same for 10:00:00-10:59:59 i.e Temperature=17.5, when the time changes to 11:00:00 i must have Temperature=18.5, upto 11:59:59.

i must consider only the hour part. Plz, help me. I am trying it from 1 week, but still no sign of any success.

Plz, give me some suggestion so that i can continue.....

Thank you Sir, for giving me your time....