title: Postgresql error : String was not recognized as a valid date time
body: <p>I am getting this error when I try to retrieve a date field  from postgresql from C#. As in <code>select datefield from table</code>.</p>
  
  <p>The system on which postgesql is running is on IST timezone.  I can not edit any settings on the database or the system on which it is deployed.  What can I do in my code to prevent this issue?</p>
  
  <p>UPDATE: The client is on MST timzone. Forgot to mention that.</p>
  
  <p>UPDTATE2 : Attaching code</p>
  
  <pre><code>DbDataAdapter myAdapter = dbFactory.NewDataAdapter(sSQL, myConnection);
  if (myConnection.State != ConnectionState.Open)
         myConnection.Open();   
  ds = new DataSet();
  myAdapter.Fill(ds, dataTableName);
  </code></pre>