To give a specific format to the date obtained throught DB2 “current date”, you can use the following method.

Get date with European format

select CHAR(current date, EUR) from sysibm.sysdummy1

1

----------

22.03.2012

1 record(s) selected.

Get date with USA format

db2 => select char(current date, USA) from sysibm.sysdummy1

1
----------
03/22/2012

1 record(s) selected.

 

Others formats:

  • USA - Use IBM standard for U.S. date and time format.
  • EUR - Use IBM standard for Europe date and time format.
  • DEF - Use date and time format associated with the territory code.
  • ISO - Use date and time format of the International Standards Organization.
  • JIS - Use date and time format of the Japanese Industrial Standard.
  • LOC-  Use date and time format in local form associated with the territory code of the database.