How change the default date format in DB2 Databases
Follow the steps below to change date format in DB2 Databases:
1 - On the command line, change your current directory to sqllib\bnd
For example:
On Windows:
c:\program files\IBM\sqllib\bnd
On UNIX:
cd /home/db2inst1/sqllib/bnd
2 - Connect to the database from the operating system shell as a user with SYSADM authority:
db2 connect to DBNAME
db2 bind @db2ubind.lst datetime ISO blocking all grant public
(In your case, substitute your database name and desired date format for DBNAME and ISO, respectively.)
The date formats available on db2 are:
DEF
Use a date and time format associated with the territory code.
EUR
Use the IBM standard for Europe date and time format.
ISO
Use the date and time format of the International Standards Organization.
JIS
Use the date and time format of the Japanese Industrial Standard.
LOC
Use the date and time format in local form associated with the territory code of the database.
USA
Use the IBM standard for U.S. date and time format.