3
I have a Postgresql database on the Windows Azure server that is set to the Brazilian standard.
If I do an SQL and run directly in Pgadminiii there from the server and run, the date is saved in Brazilian format.
But if I send my C# (local or Azure) code to execute SQL, the date is saved in American format. I already debug my code and saw that the date is Brazilian, it mounts the SQL string with the Brazilian date, but when it runs it is saved as American.
Both the code and my direct access to Postgre’s Pgadminiii are with the same user. Why does this happen? Why does manually running become Brazilian and when the code runs becomes American? Can anyone help, please? They’ve had similar problems?
Which culture is configured in your application?!
– Edney Batista da Silva
Could you post the respective snippet of your C#code, please?
– Jônatas Hudler
I had a similar problem and I solved that tag <globalization Culture="en-BR" uiCulture="en-BR" /> in webconfig inside the tag <system.web> or then configure in globlal.asax.
– William Cézar