I am running H2 *1.4.192* which declares support "*timestamp with timezone*"
data type. I create a table as below:
* create table TEST_TIME(ID INT PRIMARY KEY, NAME TIMESTAMP WITH
TIMEZONE);*
I try to insert a record like this:
* insert into TEST_TIME values (1, CURRENT_TIMESTAMP())*
It reports an error:
*Data conversion error converting "2016-09-05 18:05:11.685+00"; SQL
statement:*
*insert into TEST_TIME values (1, CURRENT_TIMESTAMP()) [22018-192]
22018/22018 (Help) *
I also try to insert record like this:
*insert into TEST_TIME values (2, PARSEDATETIME('Sat, 3 Feb 2001
03:05:06 GMT', 'EEE, d MMM yyyy HH:mm:ss z', 'en', 'GMT')) *
It reports the same error.
Could somebody shed me a light on how to inserve a "timestamp with
timezone" value? The document of H2 has no information on it. Thanks in
advance.
--
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.
