Personal tools
You are here: Home DB2 How To's How change the default date format in DB2 Databases
Navigation
Log in


Forgot your password?
 
Document Actions

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.
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls