|
|
| |
Oracle SYSDATE Function
SYSDATE The current system date & time
TO_CHAR Convert to character String
select TO_CHAR(sysdate) from dual result: 14-MAR-08
select TO_CHAR(sysdate,'DD-Mon-YYYY') from dual result: 14-Mar-2008
select TO_CHAR(sysdate,'DD-Mon-YYYY HH24:mi:ss') from dual 14-Mar-2008 15:40:45
|
|
Page 1
|
|
|  |
|
|