Hi, Sorry I don't understand.
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). > No, storing the UTC is exactly what _would_ cause a problem. If the local time is stored instead (whatever x.toString() prints), then there is no problem. This is what H2 1.4.x is doing (it doesn't store the string, but a number that represents the string). Do you recommend using strings for working with dates? Or is there a better > way? > You can use String or Timestamp in H2 1.4.x. Regards, Thomas -- 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.
