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

Reply via email to