Hi Anil, Try using CAST to explicitly cast the result to an unsigned date, like this: CAST(TO_DATE(someDate) AS UNSIGNED_DATE)
Thanks, James On Wed, Jul 9, 2014 at 8:38 PM, anil gupta <[email protected]> wrote: > 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. I > can file a jira for this. Can anyone guide me how to introduce this > function in sql language of Phoenix. > > -- > Thanks & Regards, > Anil Gupta
