time field query problems.
| From: | Steve Bradwell | Date: | Mon, 29 Jul 2002 18:41:30 +0000 |
| Subject: | time field query problems. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20860@lists.php.net to get a copy of this message | ||
Sorry to repost but I typed in the wrong sql statement in my previous post.
For some reason the below statement is not working. Can anyone tell me why?
Select EDIT_LOCK from ordmaster where EDIT_LOCK + INTERVAL 10 MINUTE < now()
AND ORDER_NO = '5' AND EDIT_LOCK > 0;
-EDIT_LOCK is a MySQL (ver 3.23.49-max) time field, allows nulls, default is
NULL.
If this cannot be done in a query, whats the best way to compare time in
php?
Thanks,
Steve.