Kbase P14996: SQL-92 equivalent function of the SQL-89 function TIME
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/03/2005 |
|
Status: Unverified
GOAL:
How to display the current time in a specific format
GOAL:
What is the SQL-92 equivalent function of the SQL-89 function TIME
FIX:
SQL-89:
=======
INSERT INTO PUB.Test (dTime) VALUES (STRING(TIME,'HH:MM'))
SQL-92:
=======
INSERT INTO PUB.Test (dTime) VALUES (TO_CHAR(CURTIME(),'HH:MI'))