When I'm sending dates to my DB2 database, I notice it automatically assumes the dates are formatted in American format. Is this something that can be altered in DB2? I'd like to be able to send dates in dd/mm/yyyy format.
Ok. I'm running DB2 8 on a WinXP machine and I'm plugging into that using ColdFusion. The machine locale is Australia.
I'm getting a date from a user via a web form and I'm sending that date, along with some other associated data, to the database. The issue I'm having is that DB2 assumes the dates are mm/dd/yyyy, unless they can't be resolved as such. So, for eg. I enter 1/9/2005 (being 1st September) and DB2 interprets that as 9th Jan. However, if I enter 30/9/2005, it gets it right.