[
https://issues.apache.org/jira/browse/SPARK-27791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16852761#comment-16852761
]
Yuming Wang commented on SPARK-27791:
-------------------------------------
Hi, [~maxgekk] Is this ticket to cover these 2 cases?
{code:sql}
SELECT interval '1' year to month;
SELECT interval '1-2' year to month;
{code}
[https://github.com/postgres/postgres/blob/df1a699e5ba3232f373790b2c9485ddf720c4a70/src/test/regress/sql/interval.sql#L180-L181]
> Support SQL year-month INTERVAL type
> ------------------------------------
>
> Key: SPARK-27791
> URL: https://issues.apache.org/jira/browse/SPARK-27791
> Project: Spark
> Issue Type: Sub-task
> Components: SQL
> Affects Versions: 2.4.0
> Reporter: Maxim Gekk
> Priority: Major
>
> The INTERVAL type must conform to SQL year-month INTERVAL type, has 2 logical
> types:
> # YEAR - Unconstrained except by the leading field precision
> # MONTH - Months (within years) (0-11)
> And support arithmetic operations involving values of type datetime or
> interval.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
