You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@drill.apache.org by "James Turton (Jira)" <ji...@apache.org> on 2020/12/18 05:59:00 UTC

[jira] [Closed] (DRILL-7824) Data Conversion Error

     [ https://issues.apache.org/jira/browse/DRILL-7824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Turton closed DRILL-7824.
-------------------------------
    Resolution: Not A Bug

> 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
>            Priority: Major
>
> 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)