[CALCITE-5619] Support PostgreSQL's TO_CHAR function

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.35.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Tim Nieradzik
• Reporter: Tim Nieradzik
• Created: 29/Mar/23 09:12
• Updated: 09/Feb/24 20:36
• Resolved: 14/Apr/23 05:55

Description

PostgreSQL has three to_char() functions:

to_char ( timestamp, text ) → text
to_char ( interval, text ) → text
to_char ( numeric_type, text ) → text

The following query cannot be parsed because the first to_char() function is not supported:

select to_char(current_timestamp, 'YYYY-MM-DD HH24:MI:SS.MS TZ')

Issue Links

• causes: CALCITE-6222 Mysql does not have to_char function
• is related to: CALCITE-759 Add DayOfWeek and other missing date/time functions
• is related to: CALCITE-2980 Implement the FORMAT clause of the CAST operator
• relates to: CALCITE-6252 BigQuery FORMAT_DATE uses the wrong calendar for Julian dates
• relates to: CALCITE-5225 No match found for function signature TO_CHAR(<CHARACTER>)
• links to: GitHub Pull Request #3134