Kbase P106432: Enhancement: Make SYSTIMESTAMP_TZ equivalent to NOW
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/08/2005 |
|
Status: Unverified
SYMPTOM(s):
Make SYSTIMESTAMP_TZ equivalent to NOW
The analogous functions SYSTIMESTAMP_TZ and NOW work somewhat differently.
In SQL, the SYSTIMESTAMP_TZ scalar function records the system time into a timestamp or timestamp with time zone datatype with a resolution of 1 second.
In 4GL, the NOW function records the system time into a datetime or datetime with time zone datatype with millisecond resolution.
The 1 second resolution is in accord with the documented functionality.
CAUSE:
Enhancement request# 20040212-037
FIX:
This enhancement has not been implemented in the product.
This enhancement suggestion is to extend the SYSTIMESTAMP_TZ scalar to have millisecond resolution, similarly to the NOW function in 4GL.