[
https://issues.apache.org/jira/browse/PHOENIX-3?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor reassigned PHOENIX-3:
----------------------------------
Assignee: Samarth Jain
This may be fixed already, but would you mind taking a look and submitting a
patch if it's not?
> 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.3
> Reporter: Harshit Bapna
> Assignee: Samarth Jain
>
> 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.2#6252)
