Kbase P4122: SQL-92. How to format the current time when using CURTIME() function ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/19/2002 |
|
Solution ID: P4122
GOAL:
SQL-92. How to format the current time when using CURTIME() function ?
FACT(s) (Environment):
Progress 9.1C
FIX:
Convert the time into character by using the TO_CHAR function.
For example, the query below inserts the current time with the format 'HH:MM':
insert into pub.test (mydate,myTime) values (curdate(), to_char(curtime(),'HH:MI'));