The following SQL generated by jOOQ fails with H2, select "ENTITY"."DATA" from "ENTITY" where "ENTITY"."CREATION_DATE" = cast(current_timestamp() as timestamp with time zone)
The error is due to the space between "time" and "zone", which should be a single word. I confirmed this in the H2 Web Console. Syntax error in SQL statement "SELECT ""ENTITY"".""DATA"" FROM ""ENTITY"" WHERE ""ENTITY"".""CREATION_DATE"" = CAST(CURRENT_TIMESTAMP() AS TIMESTAMP WITH TIME[*] ZONE) "; expected "TIMEZONE"; SQL statement: select "ENTITY"."DATA" from "ENTITY" where "ENTITY"."CREATION_DATE" = cast(current_timestamp() as timestamp with time zone) [42001-193] Is this a known issue? Thanks, Ben -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
