If your knowledge of DB2 are limited comparing others DBMS’s, sure you have wondered how you can get the date and time in the DB2 database. In this article you will discover the basic statements to get the date and time in DB2:
The following article shows simple examples of how to operate with dates in DB2 queries.
Coming from the Oracle world, you know that there is a table “dummy” call DUAL auxiliary operations used to, but in some cases very important. In DB2 this table is called sysibm.sysdummy1.