Wednesday, September 29, 2010

-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