Kent Yao created SPARK-31507:
--------------------------------
Summary: Remove millennium, century, decade, and epoch from
extract fucntion
Key: SPARK-31507
URL: https://issues.apache.org/jira/browse/SPARK-31507
Project: Spark
Issue Type: Improvement
Components: SQL
Affects Versions: 3.0.0
Reporter: Kent Yao
Extracting millennium, century, decade, millisecond, microsecond and epoch from
datetime is neither ANSI standard nor quite common in modern SQL platforms.
None of the systems listing below support these except PostgreSQL.
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions050.htm
https://prestodb.io/docs/current/functions/datetime.html
https://docs.cloudera.com/documentation/enterprise/5-8-x/topics/impala_datetime_functions.html
https://docs.snowflake.com/en/sql-reference/functions-date-time.html#label-supported-date-time-parts
https://www.postgresql.org/docs/9.1/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
