-Get current data using DB2
select current date from sysibm.sysdummy1
select current time from sysibm.sysdummy1
-Get number of days between current day and specified date using DB2
select days(current date) - days(date('1999-22-10')) from sysibm.sysdummy1
No comments:
Post a Comment