osdir.com


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Syntax of TIMESTAMP [WITHOUT TIME ZONE], TIMESTAMP WITH LOCAL TIME ZONE and TIMESTAMP WITH TIME ZONE in Calcite 1.17


Hi Calcite community:

I am using Calcite 1.17.0 and testing the syntax of constructing TIMESTAMP
[WITHOUT TIME ZONE], TIMESTAMP WITH LOCAL TIME ZONE and TIMESTAMP WITH TIME
ZONE in SELECTION. For example, I am doing tests like "SELECT TIMESTAMP
'2017-12-31 23:59:59'".

I can construct TIMESTAMP [WITHOUT TIME ZONE] without any problem. However,
I am facing troubles to construct others.

Per Calcite's website, this syntax is available:

TIMESTAMP '2017-12-31 23:59:59 America/Los Angeles'

However, my test failed with Illegal TIMESTAMP literal '2017-12-31
23:59:59 America/Los Angeles': not in format 'yyyy-MM-dd HH:mm:ss'.


I further tested

TIMESTAMP '2017-12-31 23:59:59Z'

TIMESTAMP_WITH_TIME_ZONE '2017-12-31 23:59:59 America/Los Angeles'

TIMESTAMP WITH TIME ZONE '2017-12-31 23:59:59 America/Los Angeles'

TIMESTAMP WITH LOCAL TIME ZONE '2017-12-31 23:59:59 America/Los Angeles'

TIMESTAMP_WITH_LOCAL_TIME_ZONE '2017-12-31 23:59:59 America/Los Angeles'

Neither one succeeded.


Is there anyone who happen to know what's the right way to construct
timestamp with time zones? Any help would be appreciated.

-Rui