Hello. It looks like your timezone has a DST transition from 2019-03-10 02:00:00 to 2019-03-10 03:00:00, so timestamp 2019-03-10 02:00:00 is not valid. This function always normalizes such timestamps.
You can use the TIMESTAMP WITH TIME ZONE data type to avoid issues on DST boundaries. SET @date = TIMESTAMP WITH TIME ZONE '2020-03-08 02:00:00 -07'; -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/ee8747a2-86dc-4499-af16-4e2ad54ac848%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.