[오라클]sysdate, systimestamp

 

<SQL>
SELECT
TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') AS D1,
TO_CHAR(SYSTIMESTAMP,'YYYYMMDDHH24MISS') AS D2,
TO_CHAR(SYSTIMESTAMP,'YYYYMMDDHH24MISSFF') AS  D3,
TO_CHAR(SYSTIMESTAMP,'YYYYMMDDHH24MISSFF1') AS D11,
TO_CHAR(SYSTIMESTAMP,'YYYYMMDDHH24MISSFF2') AS D12,
TO_CHAR(SYSTIMESTAMP,'YYYYMMDDHH24MISSFF3') AS D13,
TO_CHAR(SYSTIMESTAMP,'YYYYMMDDHH24MISSFF4') AS D14,
TO_CHAR(SYSTIMESTAMP,'YYYYMMDDHH24MISSFF5') AS D15,
TO_CHAR(SYSTIMESTAMP,'YYYYMMDDHH24MISSFF6') AS D16,
TO_CHAR(SYSTIMESTAMP,'YYYYMMDDHH24MISSFF9') AS D19
FROM DUAL

<결과>
D1            
--------------
20130206100343

D2            
--------------
20130206100343

D3                     
-----------------------
20130206100343603865   

D11                    
-----------------------
201302061003436        

D12                    
-----------------------
2013020610034360       

D13                    
-----------------------
20130206100343603      

D14                    
-----------------------
201302061003436038     

D15                    
-----------------------
2013020610034360386    

D16                    
-----------------------
20130206100343603865   

D19                   
-----------------------
20130206100343603865000

 

 

<SQL>
SELECT
TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS') AS D1,
TO_CHAR(SYSTIMESTAMP,'YYYY-MM-DD HH24:MI:SS') AS D2,
TO_CHAR(SYSTIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF') AS  D3,
TO_CHAR(SYSTIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF1') AS D11,
TO_CHAR(SYSTIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF2') AS D12,
TO_CHAR(SYSTIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF3') AS D13,
TO_CHAR(SYSTIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF4') AS D14,
TO_CHAR(SYSTIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF5') AS D15,
TO_CHAR(SYSTIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF6') AS D16,
TO_CHAR(SYSTIMESTAMP,'YYYY-MM-DD HH24:MI:SS.FF9') AS D19
FROM DUAL

<결과>
D1                 
-------------------
2013-02-06 10:05:56

D2                 
-------------------
2013-02-06 10:05:56

D3                           
-----------------------------
2013-02-06 10:05:56.961514   

D11                          
-----------------------------
2013-02-06 10:05:56.9        

D12                          
-----------------------------
2013-02-06 10:05:56.96       

D13                          
-----------------------------
2013-02-06 10:05:56.961      

D14                          
-----------------------------
2013-02-06 10:05:56.9615     

D15                          
-----------------------------
2013-02-06 10:05:56.96151    

D16                          
-----------------------------
2013-02-06 10:05:56.961514   

D19                         
-----------------------------
2013-02-06 10:05:56.961514000