spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jiatao Tao (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (SPARK-27546) Should repalce DateTimeUtils#defaultTimeZoneuse with sessionLocalTimeZone
Date Tue, 23 Apr 2019 08:11:00 GMT

    [ https://issues.apache.org/jira/browse/SPARK-27546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823801#comment-16823801
] 

Jiatao Tao edited comment on SPARK-27546 at 4/23/19 8:10 AM:
-------------------------------------------------------------

see an example like this:

 
{code:java}
// config spark session with "spark.sql.session.timeZone", "UTC"
val df = mockDF
// TimeZone.setDefault(TimeZone.getTimeZone("UTC"))
val date = new Date(1356998400000L) // 2013-01-01 (UTC)
val ts = df.select(lit(date).cast(TimestampType).cast(DateType)).head().getDate(0).getTime

{code}
The ts I got is: 1356969600000 (12/31/2012 UTC)

 

When I set "TimeZone.setDefault(TimeZone.getTimeZone("UTC"))", the ts is same with 1356998400000.

  !image-2019-04-23-08-10-00-475.png!

 

!image-2019-04-23-08-10-50-247.png!

 


was (Author: aron.tao):
see an example like this:

 
{code:java}
// config spark session with "spark.sql.session.timeZone", "UTC"
val df = mockDF
// TimeZone.setDefault(TimeZone.getTimeZone("UTC"))
val date = new Date(1356998400000L) // 2013-01-01 (UTC)
val ts = df.select(lit(date).cast(TimestampType).cast(DateType)).head().getDate(0).getTime

{code}
The ts I got is: 1356969600000 (12/31/2012 UTC)

 

When I set "TimeZone.setDefault(TimeZone.getTimeZone("UTC"))", the ts is same with 1356998400000.

 

 

 

> Should repalce DateTimeUtils#defaultTimeZoneuse with sessionLocalTimeZone
> -------------------------------------------------------------------------
>
>                 Key: SPARK-27546
>                 URL: https://issues.apache.org/jira/browse/SPARK-27546
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 2.4.1
>            Reporter: Jiatao Tao
>            Priority: Minor
>         Attachments: image-2019-04-23-08-10-00-475.png, image-2019-04-23-08-10-50-247.png
>
>




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org


Mime
View raw message