I am working with db2 udb v7.1 with fixpack5. I am fiding a problem when the clients connect to the database and while retrieving the date fields.My database date format is dd/mm/yyyy and country code is set to 785.
when the users access from the client(i.e. Powerbuilder) they are getting the date format as mm/dd/yyyy. this is been killing me for the last fortnight. So can u please guide me what i can do to get the database and clients to come on streamline.
I had a similar problem in one of our projects where we used MSSQL. The client wanted the date to be entered into the database in whatever format the user entered from his local machine. But b'coz the server had a specific format, the date used be added to the table in the server format. So we had to change the field type in the table to Varchar.
This may help you in solving your problem. All the best.