[ 
https://issues.apache.org/jira/browse/PHOENIX-1796?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14389523#comment-14389523
 ] 

James Taylor commented on PHOENIX-1796:
---------------------------------------

I've seen a similar issue reported, but it turned out to be a timezone issue, 
as the dates were being input in the local timezone and then the query was 
using GMT dates. If this is the issue here, Gabriel added the ability to have 
better control over consistency for timezones a while back that may help. See 
phoenix.query.dateFormatTimeZone here: http://phoenix.apache.org/tuning.html

> TO_DATE not functioning as stated in the documentation
> ------------------------------------------------------
>
>                 Key: PHOENIX-1796
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1796
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.3.0
>            Reporter: Ivan Weiss
>
> Tried to compare using > and < operators in a select query - it seems to be a 
> day off



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to