AnsweredAssumed Answered

Boomi date format in oracle format

Question asked by allan.ford577519 on Jun 23, 2017
Latest reply on Apr 8, 2018 by dcollins724067

It seems that the Boomi date format is like example '19850313 000000.000'

 

Which in Oracle is expressed like this:

YYYYMMDD HH24MISS.FF3

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:

Datatypes 

https://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements004.htm#i34510

http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions173.htm
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions172.htm

Outcomes