[
https://issues.apache.org/jira/browse/SPARK-31507?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kent Yao updated SPARK-31507:
-----------------------------
Summary: Remove millennium, century, decade, millisecond, microsecond and
epoch from extract fucntion (was: Remove millennium, century, decade, and
epoch from extract fucntion)
> Remove millennium, century, decade, millisecond, microsecond 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
> Priority: Major
>
> 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
