[jira] [Commented] (TAJO-761) Implements INTERVAL type

["Christian Schwabe (JIRA)" <ji...@apache.org>]

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