Hi,
Timestamps are currently stored in H2 in GMT.
Whenever someone inputs a timestamp literal it is turned to GMT time
using Formatter/Parser that has certain default settings.
Pattern: yyyy-MM-dd hh:mm:ss[.nnnnnnnnn]
Timezone: JVM default
Locale: JVM Default
I think the default timezone and locale would be great additions to add
as properties to the connection url.
Then the db user could decide per connection and not per database the
timezone his app is currently operating in.
Now one can do the same by using prepared statements and formatting
Timestamps after retrieving them from ResultSet.
But this could be a nice addition still for testing and debugging
situations.
- rami
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
