[ 
https://issues.apache.org/jira/browse/SPARK-27423?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Wenchen Fan reassigned SPARK-27423:
-----------------------------------

    Assignee: Maxim Gekk

> Cast DATE to/from TIMESTAMP according to SQL standard
> -----------------------------------------------------
>
>                 Key: SPARK-27423
>                 URL: https://issues.apache.org/jira/browse/SPARK-27423
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 3.0.0
>            Reporter: Maxim Gekk
>            Assignee: Maxim Gekk
>            Priority: Minor
>
> According to SQL standard, DATE is union of (year, month, day). To convert it 
> to Spark's TIMESTAMP which is TIMESTAMP WITH TIME ZONE, the date should be 
> extended by time at midnight - (year, month, day, hour = 0, minute = 0, 
> seconds = 0). The former timestamp should be considered as a timestamp at the 
> session time zone, and transformed to microseconds since epoch in UTC.



--
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