Description
Currently, Spark does not have support for `to_char`. PgSQL, however, [does|https://www.postgresql.org/docs/12/functions-formatting.html]:
Query example:
SELECT to_char(SUM(n) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING),'999999999999999999999D9')
| Function | Return Type | Description | Example |
|---|---|---|---|
| to_char(timestamp, text) | text | convert time stamp to string | to_char(current_timestamp, 'HH12:MI:SS') |
| to_char(interval, text) | text | convert interval to string | to_char(interval '15h 2m 12s', 'HH24:MI:SS') |
| to_char(int, text) | text | convert integer to string | to_char(125, '999') |
| to_char(double precision, text) | text | convert real/double precision to string | to_char(125.8::real, '999D9') |
| to_char(numeric, text) | text | convert numeric to string | to_char(-125.8, '999D99S') |
Attachments
Issue Links
- is related to
-
SPARK-28137 Data Type Formatting Functions: `to_number`
-
- Resolved
-
- links to
(2 links to)