[jira] [Created] (SPARK-44868) Convert datetime to string by `to_char`/`to_varchar`

["Max Gekk (Jira)" <ji...@apache.org>]

Max Gekk created SPARK-44868:
--------------------------------

             Summary: 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


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: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org