[
https://issues.apache.org/jira/browse/PIG-3864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Frederic Schmaljohann updated PIG-3864:
---------------------------------------
Description:
When using ToDate with a location based timezone (e.g. "Europe/Berlin") the
handling of the timezone offset is based on whether the timezone is currently
in daylight saving and not based on whether the timestamp is in daylight saving
time or not.
Example:
{noformat}
B = FOREACH A GENERATE ToDate('2014-02-02 18:00:00.000Z', 'yyyy-MM-dd
HH:mm:ss.SSSZ', 'Europe/Berlin') AS Timestamp;
{noformat}
This yields
{noformat}2014-02-02 20:00:00.000+02{noformat}
when called during daylight saving in Europe/Berlin although I would expect
{noformat}2014-02-02 19:00:00.000+01{noformat}
During standard time In Europe/Berlin, the above call yields
{noformat}2014-02-02 19:00:00.000+01{noformat}
In Europe/Berlin DST started on March 30th, 2014.
This seems pretty strange to me. If it is on purpose it should at least be
noted in the documentation.
was:
When using ToDate with a location based timezone (e.g. "Europe/Berlin") the
handling of the timezone offset is based on whether the timezone is currently
in daylight saving and not based on whether the timestamp is in daylight saving
time or not.
Example:
B = FOREACH A GENERATE ToDate('2014-02-02 18:00:00.000Z', 'yyyy-MM-dd
HH:mm:ss.SSSZ', 'Europe/Berlin') AS Timestamp;
This yields
2014-02-02 20:00:00.000+02
when called during daylight saving in Europe/Berlin although I would expect
2014-02-02 19:00:00.000+01.
During standard time In Europe/Berlin, the above call yields 2014-02-02
19:00:00.000+01
In Europe/Berlin DST started on March 30th, 2014.
This seems pretty strange to me. If it is on purpose it should at least be
noted in the documentation.
> ToDate(userstring, format, timezone) computes DateTime with strange handling
> of Daylight Saving Time with location based timezones
> ----------------------------------------------------------------------------------------------------------------------------------
>
> Key: PIG-3864
> URL: https://issues.apache.org/jira/browse/PIG-3864
> Project: Pig
> Issue Type: Bug
> Affects Versions: 0.11.1
> Reporter: Frederic Schmaljohann
>
> When using ToDate with a location based timezone (e.g. "Europe/Berlin") the
> handling of the timezone offset is based on whether the timezone is currently
> in daylight saving and not based on whether the timestamp is in daylight
> saving time or not.
> Example:
> {noformat}
> B = FOREACH A GENERATE ToDate('2014-02-02 18:00:00.000Z', 'yyyy-MM-dd
> HH:mm:ss.SSSZ', 'Europe/Berlin') AS Timestamp;
> {noformat}
> This yields
> {noformat}2014-02-02 20:00:00.000+02{noformat}
> when called during daylight saving in Europe/Berlin although I would expect
> {noformat}2014-02-02 19:00:00.000+01{noformat}
> During standard time In Europe/Berlin, the above call yields
> {noformat}2014-02-02 19:00:00.000+01{noformat}
> In Europe/Berlin DST started on March 30th, 2014.
> This seems pretty strange to me. If it is on purpose it should at least be
> noted in the documentation.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
