TIME WITH TIME ZONE

[sixinli]

Describe the bug A clear and concise description of what the bug is.

To Reproduce Steps to reproduce the behavior:

1. SELECT TIMESTAMP WITH TIME ZONE '2004-10-19 10:23:54+02'
2. Parsing this SQL using JSqlParser with this statements

org.junit.ComparisonFailure: Expected query to parse but it failed to parse (error: Encountered unexpected token: "TIMESTAMP WITH TIME ZONE" <DT_ZONE>
    at line 1, column 8.

Was expecting one of:

    "*"
    "STRAIGHT_JOIN"
) expected:<[tru]e> but was:<[fals]e>

Expected behavior expect the query to parse

System

• postgres
• java 11
• JSqlParser 4.2

[manticore-projects]

Duplicate of #1344, it is not about the Timezone but about casting the String.

Explicit Cast works

[wumpz]

works

SELECT '2004-10-19 10:23:54+02'::TIMESTAMP WITH TIME ZONE

[sixinli]

thanks for the magic fix!!