DB2獲取當前時間

DB2獲取當前時間   db2喬樂共享日期currentdate 

Sql代碼  
SELECT current date FROM sysibm.sysdummy1;  

'2012-09-20' 

Sql代碼  
SELECT current time FROM sysibm.sysdummy1;  

'14:04:04' 

Sql代碼  
SELECT current timestamp FROM sysibm.sysdummy1;  

'2012-09-20 14:04:11.343000' 

Sql代碼  
-- 插入日期  
insert into FRONT.PRODUCT_SWITCH(PRODUCT_ID, INCLUDE_SIGN, GROUP_ID, AREA, BEGIN_TERM_ID, END_TERM_ID)  
values ('000001','0','2','',current date,current date)