[
https://issues.apache.org/jira/browse/PHOENIX-5679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17016434#comment-17016434
]
Sandeep Guggilam commented on PHOENIX-5679:
-------------------------------------------
There is a change in sqlline recently where they would call the toObject()
method on the ResultSet object when there is a TIME datatype detected. Earlier
it used to be calling the toString() method on the TIME datatype result
out toString() method would format the date in YYYY-MM-DD hh:mm:ss.SSS format
but the toObject() method would return a java.sql.Date which just prints the
YYYY-MM-DD format
[~larsh] Should we just follow the convention of displaying the DATE column in
just YYYY-MM-DD format instead of YYYY-MM-DD hh:mm:ss.SSS when we do a SELECT
query containing the DATE column ?
Please advise
> Querying a DATE column with 'YYYY-MM-DD HH:MM:SS' format not returning the
> right data
> -------------------------------------------------------------------------------------
>
> Key: PHOENIX-5679
> URL: https://issues.apache.org/jira/browse/PHOENIX-5679
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.15.0
> Reporter: Sandeep Guggilam
> Priority: Major
>
> When we insert data into a DATE column with TO_DATE('YYYY-MM-DD HH:MM:SS')
> format and then query the same, it is returning back the DATE column with
> just ('YYYY-MM-DD') format but not returning the time.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
