-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Jerry,
On 1/7/20 7:42 PM, Jerry Malcolm wrote: > Summarizing what I know now... when I use the command line on the > linux instance and do a mysql query, I get the correct date (i.e. > the date that I set, the date I wanted, the date that mySQL exports > to SQL file, and the date that appears in Windows tomcat). So this > pretty much rules out the problem being in the mySQL server. I > would think this also rules out the problem being in some timezone > setting in the base Linux system hosting tomcat since I get the > right date in the command line. That only leaves the JVM; JDBC > package, and MySQL connector. The JDBC package and the MySQL connector are the same thing. They will convert correctly from the server's time zone into the JVM's time zone. > MySQL RDS instance is set to US Central timezone. So it's going to > return dates in central time, right? Sort of? See my other reply for ... details. > It appears that jdbc and/or the connector is assuming the db is gmt > and knocking off another 6 hours. Is there some place in the > datasource to tell tomcat the timezone of the database so it knows > not to convert TZ when it doesn't need to? I can't find anything > like that in the datasource documentation. Your JVM is probably in GMT/UTC. The conversion is not the problem. It's just the output that is causing you pain. - -chris -----BEGIN PGP SIGNATURE----- Comment: Using GnuPG with Thunderbird - https://www.enigmail.net/ iQIzBAEBCAAdFiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAl4VMeoACgkQHPApP6U8 pFjzWRAAlSOt1Yu3jGYUzM0zxfuaSNJ88Tu0QS2Ibt3AtuJEqwvU6LWmjS+B1DpR THxpP/RYEUbEoe9BMxm6aN4qT0DpmP5sWqbceqcOmLH1ACAGalvtX/mLh9auSXk/ +paOkUB6aZ6CNTXwth8O0c89KuKIdydw0jAcJesU32leuKzOsgPlY5Ey5QG/G6Gv YvqY61730vQ573fTzAFX84w10v+Q7+vTGxzS5RgtQcjCK6vH6jXPinzmkTOKSa3E 7gC2yHGJ0yQvRUVNYWqUS8yiBX5GmrO7bXPGxIT5jbfzdlCOUgciElLaoO1WmxTX 1tU6wX5zh3Mm3ACNN6+JRPJXUkJNO5bcfkvVRUkNoyyFyEFMHqg9edDQLMDA3IlU +KTzFLJqEsTvxiZ3t5T5b/POo8uNxleMO23AEzZZYVCTtl9pfPi9d/EtLsbwUhO2 USpLiKhEmiBe0EXFdnXJEBIkaMh7TllVZqeueTgfyMdWq42XIxb6xtfbZhRBjhYT i8tBwOXlTdI6NltW7RA9ucPcCh6esNYRwPcozXlwVBr8yJPNAWtL3y0OCO5/kGTw 73BPCiNcFmm5bR9Qh+2CRrjIzYaEmoLDEccsScfSrLIvne4mrKgyi7FkFbH7tlKk 0IPxvJrwNBjtHLPppZdnqDYaXAQX+j+mAcSbJVU9dFhjv3tBWzM= =3pbq -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
