Harshit Bapna created PHOENIX-3: ----------------------------------- Summary: TRUNC method doesn't work on column of datatype timestamp Key: PHOENIX-3 URL: https://issues.apache.org/jira/browse/PHOENIX-3 Project: Phoenix Issue Type: Bug Affects Versions: 2.2 Reporter: Harshit Bapna
On executing, select TRUNC(DATELOGGED, 'second', 30) from A, following error is observed : Type mismatch. expected: [TIME] but was: TIMESTAMP at TRUNC argument. The datatype of DATELOGGED column is timestamp. According to the doc at http://phoenix.incubator.apache.org/language/functions.html#/truncate It should ideally work on timestamp and date datatypes -- This message was sent by Atlassian JIRA (v6.1.5#6160)