You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Sandeep (Jira)" <ji...@apache.org> on 2020/12/18 03:54:00 UTC
[jira] [Created] (DRILL-7824) Data Conversion Error
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)