Sandeep created DRILL-7824:
------------------------------
Summary: Data Conversion Error
Key: DRILL-7824
URL: https://issues.apache.org/jira/browse/DRILL-7824
Project: Apache Drill
Issue Type: Bug
Components: Functions - Drill
Reporter: Sandeep
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'
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
