Details
-
Improvement
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
None
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')
Attachments
Issue Links
- causes
-
CALCITE-6222 Mysql does not have to_char function
- Closed
- is related to
-
CALCITE-759 Add DayOfWeek and other missing date/time functions
- Open
-
CALCITE-2980 Implement the FORMAT clause of the CAST operator
- Closed
- relates to
-
CALCITE-5225 No match found for function signature TO_CHAR(<CHARACTER>)
- Closed
-
CALCITE-6252 BigQuery FORMAT_DATE uses the wrong calendar for Julian dates
- Closed
-
CALCITE-6572 Add more tests for NULL arguments to TO_CHAR functions
- Closed
- links to