It works, thanks so much. Mike
在 2015年7月31日星期五 UTC+8上午2:04:16，l.garulli写道： > > 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] <javascript:>> > 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] <javascript:>. >> 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.
