[ https://issues.apache.org/jira/browse/PHOENIX-2475?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kevin Liew updated PHOENIX-2475: -------------------------------- Issue Type: Improvement (was: New Feature) > Support timestamp and date arithmetic > ------------------------------------- > > Key: PHOENIX-2475 > URL: https://issues.apache.org/jira/browse/PHOENIX-2475 > Project: Phoenix > Issue Type: Improvement > Affects Versions: 4.6.0 > Reporter: Kevin Liew > Priority: Minor > Labels: date, newbie, phoenix, timestamp > > 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)