[CALCITE-5496] Support time zones when parsing TIMESTAMP WITH LOCAL TIME ZONE

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Oliver Lee
• Created: 25/Jan/23 22:49
• Updated: 13/Mar/23 05:45

Description

In Avatica, DateTimeUtils TIMESTAMP_FORMAT_STRING doesn't handle time zones.

TIMESTAMP_FORMAT_STRING consists of DATE_FORMAT_STRING + " " + TIME_FORMAT_STRING which is "HH:mm:ss"
 
i.e. in Calcite quidem tests if we run 
DATETIME(TIMESTAMP "2008-12-25 05:30:00+07", "America/Los_Angeles") as datetime_tstz
 
 

Error:

 

Illegal TIMESTAMP WITH LOCAL TIME ZONE literal '2008-12-25 05:30:00+07': not in format 'yyyy-MM-dd HH:mm:ss'

Issue Links

• is duplicated by: CALCITE-5497 Support time zones when parsing TIMESTAMP literals
• is related to: CALCITE-5508 Add constructor functions for DATE, TIME, TIMESTAMP, DATETIME