You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "xiaozhihong (Jira)" <ji...@apache.org> on 2021/07/19 08:24:00 UTC

[jira] [Commented] (IOTDB-1510) An error is reported when import data which time format is "yyyy/MM/dd HH:mm:ss"

    [ https://issues.apache.org/jira/browse/IOTDB-1510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17383137#comment-17383137 ] 

xiaozhihong commented on IOTDB-1510:
------------------------------------

!image-2021-07-19-16-17-02-499.png!

The format "yyyy.MM.dd HH:mm:ss " or "ISO8601 standard time format" is as the same.

> An error is reported when import data which time format is "yyyy/MM/dd HH:mm:ss" 
> ---------------------------------------------------------------------------------
>
>                 Key: IOTDB-1510
>                 URL: https://issues.apache.org/jira/browse/IOTDB-1510
>             Project: Apache IoTDB
>          Issue Type: Bug
>          Components: Server
>    Affects Versions: 0.12.1
>            Reporter: xiaozhihong
>            Priority: Minor
>         Attachments: image-2021-07-19-16-17-02-499.png
>
>
> data like this :
> time,root.ln.wf01.wt01.temperature,root.ln.wf01.wt01.status
> 2021-07-07 12:30:35,20.35,true
> 2021/07/07 13:30:35,25.20,false
> 2021.07.07 14:30:35,30.22,true
> 2021-07-07T15:30:35+08:00,22.32,false
> The execution result is:
> Starting IoTDB Client Import Script
> ------------------------------------------
> Start to import data from: import2.csv
> Import from: import2.csv 0% │ │ 0/5 (0:00:00 / ?) Importing...
> Encounter an error, because: Input time format 2021/07/07 13:30:35error. Input like yyyy-MM-dd HH:mm:ss, yyyy-MM-ddTHH:mm:ss or yyyy-MM-ddTHH:mm:ss.SSSZ
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)