[jira] [Updated] (SPARK-43815) Add SQL functions to_varchar alias for to_char

["Richard Yu (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SPARK-43815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Richard Yu updated SPARK-43815:
-------------------------------
    Summary: Add SQL functions to_varchar alias for to_char  (was: Add SQL functions to_varchar and extend to_char functionality)

> Add SQL functions to_varchar alias for to_char
> ----------------------------------------------
>
>                 Key: SPARK-43815
>                 URL: https://issues.apache.org/jira/browse/SPARK-43815
>             Project: Spark
>          Issue Type: New Feature
>          Components: SQL
>    Affects Versions: 3.4.1
>            Reporter: Richard Yu
>            Priority: Major
>
> We want to add support for the follow functions:
>  * to_varchar() as an alias for to_char()
>  * Expand to_char() to take date, timestamp and binary expression as the first argument. For date and timestamp expression, the function will be equivalent to date_format(expr, fmt) . For binary expression, the function will be equivalent to base64() , hex(), and decode(<expr>, 'UTF-8') for fmt base64, hex, and UTF-8 respectively.
>  * timediff() as an alias for timestampdiff()



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org