Is there any solution to this? PreparedStatement.setTimestamp(int parameterIndex, Timestamp x) gives you the milliseconds since the Epoch without any timezone. It may be the result of converting some future date in Middle-earth. Now the in Elbonia residing server stores it as its local time and after the Elbonia's government changes the DST rules, you'll be off (while storing the UTC works).
On the one hand, this problem happens only when dealing with multiple timezones. OTOH it expands an Elbonia's local glitch to the whole world. The sad thing is that there's nothing like setLocalDate(int parameterIndex, LocalDate x). Do you recommend using strings for working with dates? Or is there a better way? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
