Query  문 :
        Select current timestamp, current time, current date from
        sysibm/sysdummy1                                        
결과 : CURRENT TIMESTAMP           CURRENT TIME  CURRENT DATE
       2006-11-24-15.18.00.295088    15:18:00      06/11/24  
---------------------------------------------------------------------
Query  문 :
       SELECT CURDATE() SYS_DATE,CAST(CURTIME() AS CHAR(8)) SYS_TIME
       FROM SYSIBM/SYSDUMMY1 
결과 :SYS_DATE  SYS_TIME
      06/11/24  15:21:16
---------------------------------------------------------------------
Query  문 : 
        SELECT CHAR(CURDATE(),ISO) SYS_DATE,
               CAST(CURTIME() AS CHAR(8)) SYS_TIME 
        FROM SYSIBM/SYSDUMMY1 
결과 :SYS_DATE    SYS_TIME
      2006-11-24  15:24:01
---------------------------------------------------------------------
Query  문 :
       select char(date(cast('20061120091022' as timestamp)),ISO)
       from SYSIBM/SYSDUMMY1                                     
결과 : CHAR conversion
       2006-11-20   
---------------------------------------------------------------------
Query  문 :
       select char(time(cast('20061120091022' as timestamp)),ISO)
       from SYSIBM/SYSDUMMY1                                     
결과 : CHAR conversion
       09.10.22   
---------------------------------------------------------------------
Query  문 :
       select cast('20061120091022' as timestamp)
       from SYSIBM/SYSDUMMY1                                     
결과 : CAST function            
       2006-11-20-09.10.22.000000