Peter Toth created SPARK-27881:
----------------------------------

             Summary: Support CAST (... FORMAT <pattern>) expression
                 Key: SPARK-27881
                 URL: https://issues.apache.org/jira/browse/SPARK-27881
             Project: Spark
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 3.0.0
            Reporter: Peter Toth


SQL:2016 standard supports the following Cast functions
{noformat}
CAST(<datetime> AS <char string type> [FORMAT <template>])
CAST(<char string> AS <datetime type> [FORMAT <template>])
{noformat}
to specify patterns to use during cast.

Oracle DB 18 already supports it: 
https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/CAST.html

There is an initiative in Impala: IMPALA-4018 and Hive HIVE-21575 to support.
(Please note that accepting the {{CAST (... FORMAT <pattern>)}} is just one 
part of these tickets.)



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to