[DRILL-7824] Data Conversion Error

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Bug
• Component/s: Functions - Drill
• Assignee: Unassigned
• Reporter: Sandeep
• Created: 18/Dec/20 03:53
• Updated: 18/Dec/20 07:58
• Resolved: 18/Dec/20 05:58

Description

I need to convert the date from17-SEP-20 03.06.45.000000000 PM TO '2020-12-16 00:00:00' 

I have tried all the avialble to_char, date and son on but nothin ghas helped. can any one please advise..
select columns[5] audit_date_time from  s3_ccr.`S3_test/com_card.csv`

Data in the CSV File 

17-SEP-20 03.06.45.000000000 PM
17-SEP-20 03.06.45.000000000 PM
05-OCT-20 03.06.45.000000000 PM
05-OCT-20 03.06.45.000000000 PM
CONVERT TO 

  '2020-12-16 00:00:00'