title: MySQL DATETIME and TIMESTAMP to java.sql.Timestamp to ZonedDateTime
body: <p>I am wondering how the conversion works in this.  MySQL server (5.6) treats TIMESTAMP as zone-adjusted (and internally stored in/retrieved from UTC).  It also treats DATETIME as having no zone.  </p>
  
  <p>On the Java side, I am recommended to read into <code>java.sql.Timestamp</code> in either case.  Is there a zone-type conversion taking place (when going through MySQL-connector 5.1.37) from MySQL's DATETIME to <code>java.sql.Timestamp</code> (such as to apply the client system zone) ?  </p>
  
  <p>In the end, there is only one zone for my server and clients, and so I maintain a specific ZoneId (in app code) to get to <code>ZonedDateTime</code>.  But I would like to work with <code>ZonedDateTime</code>, going back and forth to the database stored as DATETIME.  A simple example of conversion will be appreciated! </p>