Hi community,
I use an Innovator SQL procedure to get some data that is merged with a second database. The SQL procedure is called from a server Method
When I test the procedure in SQL, date properties like modified_on are shown as in correct regular Innovator db format:
But the SQL procedure doesn´t return the date in this neutral UTC format to the Server Method. Instead of the shown date in the SQL, I get a converted date that looks like this:
7/13/2002 1:49:27 PM
In my case the date is later displayed in a Form, but in my country nobody uses this date format.
I am able convert the date into correct DMY-format in C# or SQL. But these steps are unnecessary complicated cause of the American date in between.
I wonder why I get the American MDY-date at the first place. I use German locals for Innovator and the server itself.
Does anyone know, what can cause dates to be converted to American format when using SQL procedures? Is there away to prevent it?
Thanks for any hint!
Angela