Get DB2 date and time

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:

Operations with dates in DB2

The following article shows simple examples of how to operate with dates in DB2 queries.

DUAL Table DB2: sysibm.sysdummy1

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.