When you want to convert a String to a timestamp with milliseconds and you are only getting zero’s for milliseconds in your database make sure that the following option is disabled in the session (Config Object tab) :
If this is enabled the milliseconds will be truncated.
You can use the following formula to convert a string to a timestamp with milliseconds :
to_date(‘2013-09-01 12.14.16.627000’,‘YYYY-MM-DD HH24.MI.SS.US’ )