In my database(mysql 4.0) table has time field , time is recorded in 0000-00-00 00:00:00 format.

My jsp page is set to refresh in every 10 seconds. So what i need is , i want to display table records which its time field is between
( currenttime - (currenttime- 1 hour)) , so can u pls help me to solve that sql ?

thx and regards