[
https://issues.apache.org/jira/browse/SPARK-44868?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hyukjin Kwon resolved SPARK-44868.
----------------------------------
Fix Version/s: 4.0.0
Resolution: Fixed
Issue resolved by pull request 42534
[https://github.com/apache/spark/pull/42534]
> Convert datetime to string by `to_char`/`to_varchar`
> ----------------------------------------------------
>
> Key: SPARK-44868
> URL: https://issues.apache.org/jira/browse/SPARK-44868
> Project: Spark
> Issue Type: New Feature
> Components: SQL
> Affects Versions: 4.0.0
> Reporter: Max Gekk
> Assignee: Max Gekk
> Priority: Major
> Fix For: 4.0.0
>
>
> Expand {{to_char()}} to take date and timestamp expression as the first
> argument. For date and timestamp expression, the function will be equivalent
> to {{date_format(expr, fmt)}}
> The goal is to achieve feature parity with other systems, and make the
> migration to Spark SQL easier:
> - Snowflake: https://docs.snowflake.com/en/sql-reference/functions/to_char
> - PostgreSQL:
> https://www.postgresql.org/docs/current/functions-formatting.html
> - MariaDB: https://mariadb.com/kb/en/to_char/
> - DB2: https://www.ibm.com/docs/en/db2/11.5?topic=sf-char
> - Exasol:
> https://docs.exasol.com/db/latest/sql_references/functions/alphabeticallistfunctions/to_char%20(datetime).htm
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
