I thought I understood the behaviour of timestamp values, but now I've just been reading the tutorial: http://www.h2database.com/html/tutorial.html#date_time and I got confused. It says:
"Date, time and timestamp values support ISO 8601 formatting, including time zone: CALL TIMESTAMP '2008-01-01 12:00:00+01:00'; If the time zone is not set, the value is parsed using the current time zone setting of the system ....'" I took "if the time zone is not set" to mean "if a time zone is not included with the timestamp value". But then, given the actual behaviour, I can only make sense of this if I change it to the _opposite_, i.e. to read something like: "If a time zone is included with the timestamp value, the value is parsed using the current time zone setting of the system". It appears that timestamp values _without_ a time zone are parsed _without_ using the current time zone setting of the system. (The actual behaviour seems to be all fine; it's the wording of this tutorial text that I don't get ... at least, I think it's that way around!) -- 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
