[SPARK-28516] Data Type Formatting Functions: `to_char` - ASF JIRA

Log work

Agile Board

Rank to Top

Rank to Bottom

Attach files

Attach Screenshot

Bulk Copy Attachments

Bulk Move Attachments

Voters

Watch issue

Watchers

Convert to Issue

Move

Link

Clone

Labels

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

Delete

XML

Word

Printable

JSON

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')`