Our actual databse is Oracle and we started to use in-memory H2 databases 
for our integration testing. But while running the tests, our applications 
started throwing below exceptions (I am sure, we will have many more but 
this is where I got struck currently): 


*Error:*

Caused by: org.h2.jdbc.JdbcSQLException: Invalid TO_CHAR format 
"yyyy-MM-dd""T""HH24:MI:SS.FFTZHTZM"; SQL statement:



*SQL being used within the application: *


select TO_CHAR(e.enddate_utc,'yyyy-MM-dd"T"HH24:MI:SS.FFTZHTZM') as date_utc

from table_name (I can't change this SQL as we have this kind of SQL's 
across the whole application and team don't want to change code)




-- 
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.

Reply via email to