Thread: My sql query
06-21-04, 01:49 #1Registered User
- Join Date
- Jun 2004
Unanswered: My sql query
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