phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kevin Liew (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-2475) Support timestamp and date arithmetic
Date Tue, 01 Dec 2015 22:56:11 GMT
Kevin Liew created PHOENIX-2475:
-----------------------------------

             Summary: Support timestamp and date arithmetic
                 Key: PHOENIX-2475
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2475
             Project: Phoenix
          Issue Type: New Feature
    Affects Versions: 4.6.0
            Reporter: Kevin Liew
            Priority: Minor


Create a timestamp table and insert a timestamp
{noformat}create table timestamp_table (ts timestamp primary key)upsert into timestamp_table
values ('1995-05-02 01:01:01'){noformat}

Example test case
{noformat}select ts + 1 from timestamp_table{noformat}

Expected result:
The timestamp with one day added to it
{noformat}1995-05-03 01:01:01{noformat}

Actual result:
the unmodified timestamp



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message