[
https://issues.apache.org/jira/browse/TAJO-761?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14092866#comment-14092866
]
Christian Schwabe commented on TAJO-761:
----------------------------------------
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.
> Implements INTERVAL type
> ------------------------
>
> Key: TAJO-761
> URL: https://issues.apache.org/jira/browse/TAJO-761
> Project: Tajo
> Issue Type: Sub-task
> Reporter: Hyoungjun Kim
> Assignee: Hyoungjun Kim
> Fix For: 0.9.0, 0.8.1
>
> Attachments: TAJO-761.patch, TAJO-761_2.patch, TAJO-761_3.patch,
> TAJO-761_4.patch, TAJO-761_5.patch, TAJO-761_6.patch
>
>
> In order to provide the following features, INTERVAL Type is required.
> {noformat}
> babokim# select timestamp '2001-09-28 01:00' + interval '23 hours';
> ?column?
> ---------------------
> 2001-09-29 00:00:00
> (1 row)
> babokim=# select date '2001-10-01' - date '2001-09-28';
> ?column?
> ----------
> 3
> (1 row)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
