You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@phoenix.apache.org by "Xinyi Yan (JIRA)" <ji...@apache.org> on 2019/03/07 18:45:00 UTC
[jira] [Commented] (PHOENIX-4931) There is a bug in the processing
date and time
[ https://issues.apache.org/jira/browse/PHOENIX-4931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16787089#comment-16787089 ]
Xinyi Yan commented on PHOENIX-4931:
------------------------------------
!Screen Shot 2019-03-07 at 10.42.05 AM.png!
I guess it is not a Phoenix problem, u can try to convert your input into a timestamp and convert it back.
> There is a bug in the processing date and time
> ----------------------------------------------
>
> Key: PHOENIX-4931
> URL: https://issues.apache.org/jira/browse/PHOENIX-4931
> Project: Phoenix
> Issue Type: Improvement
> Affects Versions: 4.14.0
> Reporter: Jollygrass
> Priority: Minor
> Attachments: Screen Shot 2019-03-07 at 10.42.05 AM.png
>
>
> 0: jdbc:phoenix:> select time'1582-10-14 00:00:00.0';
> +------------------------------------------+
> | TIME '1582-10-04 00:00:00.000' |
> +------------------------------------------+
> | 1582-10-04 00:00:00.000 |
> +------------------------------------------+
> 1 row selected (0.001 seconds)
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)