DB2与Oracle获取系统时间
Oracle中系统时间比较熟悉 是select sysdate from dual;
db2中则是 SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1
还有
select CURRENT DATE from SYSIBM.SYSDUMMY1;获得日期
select CURRENT TIME from SYSIBM.SYSDUMMY1;获得时间
Oracle中系统时间比较熟悉 是select sysdate from dual;
db2中则是 SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1
还有
select CURRENT DATE from SYSIBM.SYSDUMMY1;获得日期
select CURRENT TIME from SYSIBM.SYSDUMMY1;获得时间