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]