[PHOENIX-5679] Querying a DATE column with 'YYYY-MM-DD HH:MM:SS' format not returning the right data

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Bug
• Affects Version/s: 4.15.0
• Assignee: Sandeep Guggilam
• Reporter: Sandeep Guggilam
• Created: 14/Jan/20 07:44
• Updated: 13/Feb/20 19:32
• Resolved: 13/Feb/20 19:32

Description

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.