[CALCITE-5498] BigQuery TIMESTAMP() function short notation for timezone offsets isn’t supported in Java 8

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.34.0
• Assignee: Julian Hyde
• Reporter: Oliver Lee
• Created: 25/Jan/23 22:56
• Updated: 14/Mar/23 13:53
• Resolved: 10/Feb/23 17:02

Description

DateTimeFormatter had this issue in Java 8, fixed in Java 9 and beyond. 
 
https://bugs.java.com/bugdatabase/view_bug.do?bug_id=8210336 
https://bugs.java.com/bugdatabase/view_bug.do?bug_id=8032051 
 
 
2013-12-11T21:25:04.800842+01:00 is supported
2013-12-11T21:25:04.800842+01 is not supported
 
Sounds low priority but we should investigate how to have consistent behavior

Issue Links

• is a child of: CALCITE-5180 Implement BigQuery functions for DATE, TIME, TIMESTAMP, DATETIME
• relates to: CALCITE-5508 Add constructor functions for DATE, TIME, TIMESTAMP, DATETIME