It seems that the Boomi date format is like example '19850313 000000.000'
Which in Oracle is expressed like this:
but then if the Oracle column data type being worked with is of type date rather than timestamp then a person might want to do something like this in a standard update statement :
to_date(substr(?,1,15) ,'YYYYMMDD HH24MISS')
(otherwise an oracle message is given as per: ORA-01821: date format not recognized)
Also also interested in catering for setting null dates .. So will test what occurs when a null date comes into this also.
Please see also Oracle docs: