[
https://issues.apache.org/jira/browse/PHOENIX-1076?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor reopened PHOENIX-1076:
-----------------------------------
Anil tried the following query:
select * from events where dummy_date=CAST(TO_DATE('2012-12-23',
'yyyy-MM-dd') AS UNSIGNED_DATE) and id='1234' limit 50;
But, got following error:
Error: ERROR 602 (42P00): Syntax error. Missing "LPAREN" at line 1, column
30. (state=42P00,code=602)
> to_unsigned_date() function missing in sql of Phoenix
> -----------------------------------------------------
>
> Key: PHOENIX-1076
> URL: https://issues.apache.org/jira/browse/PHOENIX-1076
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 3.0.0
> Reporter: Anil Gupta
>
> Hi All,
> Phoenix has a DataType Unsigned_Date but now i am unable to use these columns
> for filtering. For using a date column in sql query i can use to_date(). I
> think similarly we need to have to_unsigned_date function. Can anyone guide
> me how to introduce this function in sql language of Phoenix?
> --
> ~Anil Gupta
--
This message was sent by Atlassian JIRA
(v6.2#6252)
