title: date format issue with google data studio (postgres)
body: <p>I'm using Postgres connector from a cloud based server to Google Data Studio, to pull in all my Zoho CRM data so that I can build some dashboards in Google Data Studio. </p>
  
  <p>Problem is, for some odd reason it's refusing to accept some of my date fields, while others it does. Even the exact same field, in one of my Zoho CRM tables it works, another location (sep zoho account) it won't. </p>
  
  <p>I get this error: </p>
  
  <p>Data Set Configuration Error
  Data Studio cannot connect to your data set.</p>
  
  <p>Sorry, we encountered an error and were unable to complete your request.</p>
  
  <p>Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
  Error ID: e1c58806</p>
  
  <p>Nothing I've done seems to help. </p>
  
  <p>I'm using Panopoly.io as the server. </p>
  
  <p>Zoho CRM Enterprise </p>
  
  <p>And obviously Google Data Studio. </p>
  
  <p>Data Set Configuration Error
  Data Studio cannot connect to your data set.</p>
  
  <p>Sorry, we encountered an error and were unable to complete your request.</p>
  
  <p>Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
  Error ID: e1c58806</p>