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

Richard Yu updated SPARK-43815:
-------------------------------
    Description: 
We want to add the alias to_varchar for the function to_char. 

For users who are migrating to Spark SQL such that the SQL engine they formerly 
used supported to_varchar instead of to_char, this change would minimize the 
number of chars to their application to ensure it is compatible with Spark SQL 
syntax and support.

  was:
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()


> 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 the alias to_varchar for the function to_char. 
> For users who are migrating to Spark SQL such that the SQL engine they 
> formerly used supported to_varchar instead of to_char, this change would 
> minimize the number of chars to their application to ensure it is compatible 
> with Spark SQL syntax and support.



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

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

Reply via email to