Hi, I think the current documentation is correct, and I don't see how it could be written to be more clear.
> It appears that timestamp values _without_ a time zone are parsed > _without_ using the current time zone setting of the system. If that would be true, which timezone would be used then, if the timezone is not specified? Regards, Thomas On Tue, Feb 7, 2017 at 3:14 AM, Richard Walker < richard.walker.a...@gmail.com> wrote: > 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 h2-database+unsubscr...@googlegroups.com. > To post to this group, send email to h2-database@googlegroups.com. > Visit this group at https://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.