Hi,
Try forcing datetime. Look at:
http://orientdb.com/docs/last/orientdb-etl.wiki/Transformer.html#csv and
set the "columns" field in CSV transformer, like:
{ "csv": { "separator": ",", "columns":["date:datetime", "type:string",
"phone:string", "old_token:string", "new_token:string"] } }
Best Regards,
Founder & CEO
OrientDB <http://orientdb.com/>
On 30 July 2015 at 17:30, Mike Shi <[email protected]> wrote:
> Hi,
>
> I try to use etl to import my data file with csv format, there is a field
> that stores datetime with format "YYYY-mm-dd HH:MM:SS", after import, this
> field becomes "YYYY-mm-dd 00:00:00" in OrientDB, it confused me very much,
> how to solve it?
>
> the csv content looks like below:
>
> "date", "type", "phone", "old_token", "new_token"
> "2015-07-28 00:00:23", "new token created", "", "",
> "8264eb65-685d-4936-9421-feb27832de7d"
> "2015-07-28 00:07:33", "new token created", "", "",
> "d62b184c-0602-404c-a9c6-2e327aa2ce20"
>
> After etl import, the date field becomes "2015-07-28 00:00:00"
>
> Thanks very much.
>
> Mike
>
> --
>
> ---
> You received this message because you are subscribed to the Google Groups
> "OrientDB" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
