DB2当前日期查询
SELECT current date FROM sysibm.sysdummy1
取得当前时分秒:
SELECT current time FROM sysibm.sysdummy1
取得当前年月日时分秒:
SELECT current timestamp FROM sysibm.sysdummy1
发布时间: 2013-11-09 17:06:41 作者: rapoo
DB2当前日期查询
SELECT current date FROM sysibm.sysdummy1
取得当前时分秒:
SELECT current time FROM sysibm.sysdummy1
取得当前年月日时分秒:
SELECT current timestamp FROM sysibm.sysdummy1