I am running an Informix Stored Procedure from both a PowerBuilder GUI and a Java API. When I run the procedure from the GUI (or from Informix itself), the default date format is mm/dd/yyyy; however the same procedure run from Java has a date format of yyyy-mm-dd, this is a problem because the stored procedure 'assumes' that the date will convert to string in mm/dd/yyyy and it errors when it is not in that form.

My Question: Is there a way to change the Java default string format for a date ( I am guessing that somehow that is being passed to Informix and it is trying to oblige ).

Any insight into this issue would be appreciated!