[
https://issues.apache.org/jira/browse/TAJO-1003?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14093763#comment-14093763
]
Hyunsik Choi commented on TAJO-1003:
------------------------------------
Christian also reported the following bug in TAJO-761.
bq. In my case by tipping >> SELECT timestamp '2001-09-28 01:00' + INTERVAL '23
hours'; I get the following result: '2001-09-28 23:00:00'. There is missing one
hour. Can anyone agree with that? I use the version 0.9.0-SNAPSHOT.
bq. >> SELECT timestamp '2001-09-28 01:00' INTERVAL + '1 days' results in
'2001-09-29 00:00:00' // There is one hour missing. I think all functions
should be checked again on your correctness.
> wrong converting to_timestamp(text, text)
> -----------------------------------------
>
> Key: TAJO-1003
> URL: https://issues.apache.org/jira/browse/TAJO-1003
> Project: Tajo
> Issue Type: Bug
> Components: function/udf
> Affects Versions: 0.9.0
> Environment: 0.9.0-SNAPSHOT
> Reporter: Christian Schwabe
> Assignee: Hyunsik Choi
>
> >> SELECT to_timestamp('2011-11-11', 'YYYY-MM-DD'); results in '2011-11-10
> >> 23:00:00' I would have expected the following result '2011-11-11 00:00:00'
> ALSO:
> >> SELECT to_timestamp(2011-11-11', 'DD-MM-YYYY'); results in '0017-05-02
> >> 23:00:00'
--
This message was sent by Atlassian JIRA
(v6.2#6252)
