title: How to set DateTime.Now when inserting in postgresql table?
body: <p>We ship images and the default culture setting for our image is MDY.</p>
  
  <p>The customer server where the image is installed has a locale of DMY has been using our image for a few days and then noticed datestyle errors with dates (i.e.  when inserting a DateTime.Now() into a table).</p>
  
  <p>We have tried changing the postgreSQL  locale to DMY (in postgresql.conf) but with no luck.</p>
  
  <p>I was thinking about converting all DateTime.Now() calls in my C# app to DMY format.</p>
  
  <p>I also noticed that I could set   in my web.config which may help.</p>
  
  <p>As I cannot seem to change the postgreSQL settings what are my options?</p>
  
  <p>Another option I was thinking was to uninstall postgreSQL  and then install it again with the correct locale set (as long as I backup up my database). Hopefully this will work.</p>