I have a PostgreSQL database on the Windows Azure server that is set to the Brazilian standard.
If I do a SQL and execute directly on PgAdminIII from the server and execute, the date is saved in the Brazilian format.
But if I have my C # code (local or Azure) run SQL, the date is saved in the American format. I have done a debug in my code and I saw that the date is Brazilian, it mounts the SQL string with the Brazilian date, but when it executes it it is saved as American.
Both the code and my direct access to PgAdminIII from Postgre are with the same user. Why does it happen? Why is running manually Brazilian and when the code executes is American? Can someone help, please? Have you ever had a similar problem?