Kbase P52980: SQL-92: Why SYSDATE function does not return time?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
SQL-92: Why SYSDATE function does not return time?
FIX:
SYSDATE function returns system date (e.g. '12/31/03') and SYSTIME returns system time (e.g. '10:20:15'). In order to return both date and time in SQL-92 (e.g '12/31/03 10:20:15'), use SYSTIMESTAMP scalar function.