I'm trying to ETL import from a MySQL database. currently the information 
is in a string with mm/dd/yyyy hh:mm:ss tt format. ex. 8/22/2013 9:43:05 AM

I can't change the format in the database because I have another program 
writing the information to it, but I want to be able to move it into 
orientdb.

Tested this as a transform.

{ "field": { "fieldName": "time_modified", "expression": "date( 
$time_modified, 'mm-dd-yyyy hh:mm:ss tt' )" } }


How can I use the ETL import to convert it to the proper datetime format?

Alternatively I can leave it as a string, but then I don't think I can make 
calculations against it.

-- 

--- 
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.

Reply via email to