Kbase P115403: The SQL-92 NOW() and CURDATE() functions return the same value with subsequent queries
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/08/2006 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1A
OpenEdge 10.0x
Progress 9.1x
SYMPTOM(s):
The SQL-92 NOW() and CURDATE() functions return the same value with subsequent queries
The SQL-92 NOW() and CURDATE() function does not refresh the data and time
The SQL-92 server caches the initial value of the NOW() and CURDATE() functions
The returned value of the NOW() and CURDATE() functions do not change between queries
CURETIME works as expected.
CAUSE:
This is a known issue being investigated by Development
FIX:
As a workaround in Progress 9.1D05 or higher, use the SYSTIMESTAMP() function instead of the NOW() function or SYSDATE() instead of the CURDATE() function.