If you wish to find out if the database connection API is buggy. Is the result when you use select query from each of the operating system same.
Select column_name from table; If select on both return values are same then likely the database API is buggy. You have choice of two database connection APIs. One API is tomcat specific. The other is vendor neutral. On Tue, 7 Jan 2020, 21:09 Michael Osipov, <micha...@apache.org> wrote: > Am 2020-01-07 um 21:58 schrieb Jerry Malcolm: > > This may be more of a Java question than Tomcat. But I'm not sure. I > > have the same code, talking to the same MySql Linux (AWS) database. I > > read a date column value in a Tomcat app. After calling > > resultSet.getDate(...) I printed the date instance and the getTime() > value: > > > > On windows: 2019-02-01 1549000800000 > > > > On linux: 2019-01-31 1548979200000 > > > > Again this is the SAME line of code in java reading the SAME field in > > the SAME database. Only thing different is Linux/Windows OS. The date > > is supposed to be 2/1/2019 and shows that in phpMyAdmin. > > > > I've been running on Linux for a few months. But I don't have an > > extensive background in the specifics of Linux. I'm sure there must be > > something that is configured differently. I'm at a loss. But this is > > not a trivial problem. I do monthly billing. My dates need to be > accurate. > > Have you verified that you aren't tricked by any timezone issues? > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >
