By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,589 Members | 2,255 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,589 IT Pros & Developers. It's quick & easy.

DB2 date display and formatting

mkozma
P: 1
Hi, I know there are many articles on this topic but none seem to solve my problem.
I have migrated a database (in US format) from SQL server 2005 to DB2 v9. The DB2 needs to work woth Australian date formatting (dd/mm/yyyy). I have tried using the BIND command on the database and it runs successfully but nothing seems to change. The display format in my Control Center is always mmm dd, yyyy (eg Aug 16, 2007) and I can't find where to change this anywhere. When I try entering Australian date format '16/10/2007' into the database I receieve errors because it doesn't know month 16 (of course!).
questions are:
1. How do I change the Control Center date display to dd/mm/yyyy?
2. How do I change the database date format also to dd/mm/yyyy?
Any help is appreciated.
Oct 16 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.