-DB] time field query problems.
Steve,
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
Steve,
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