[CALCITE-5027] Incorrect format for timestamp literals in SqlDialect#quoteTimestampLiteral

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.31.0
• Component/s: core
• Labels: pull-request-available
• Assignee: xiong duan
• Reporter: Gregory Hart
• Created: 02/Mar/22 00:45
• Updated: 03/Aug/22 16:21
• Resolved: 12/Apr/22 03:06

Description

The SqlDialect#quoteTimestampLiteral method uses the wrong format for standard SQL. Instead of "day of month" it uses "day of year", and instead of seconds is uses milliseconds. To fix this method, the format should be changed to: 

yyyy-MM-dd HH:mm:ss

Issue Links

• is related to: CALCITE-5039 View:Timestamp cannot query Data:Long in GMT+8 TimeZone Env
• links to: GitHub Pull Request #2767