ORACLE·sql

sysdate

administrators 2009. 12. 11. 15:23

SELECT
    SYSDATE
FROM DUAL

 

 

 

SELECT
    TO_CHAR( SYSDATE, 'yyyy.MM.dd') c_date
FROM DUAL

 

 

SELECT
    TO_CHAR (
             TO_DATE (
                      '20091025' || '000001', 'YYYY-MM-DD HH24:MI:SS'),
                      'yyyy.MM.dd'
            ) c_date
FROM DUAL