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....