You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Kevin Liew (JIRA)" <ji...@apache.org> on 2015/12/01 23:56:11 UTC
[jira] [Created] (PHOENIX-2475) Support timestamp and date
arithmetic
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)