Skip to Main Content
Forums

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Formatting String to Date in BPEL

629951Aug 29 2008 — edited Feb 27 2020
Is there a way to format a String value to date in BPEL.

I am getting date in the form of String and I need to push this date value into Oracle database to a field which is of datatype Date. I dont see any appropriate function in BPEL which is allowing me to do this.

For example my input to BPEL is "01/01/2010" and I have to convert that string in to date type variable and assign it to one of the fields in one of the tables in Oracle database.

I am using xp20:format-dateTime function but it is also giving me time which I am not able to insert into the database as the field is specified as date.

I am trying to do this conversion in assign process and transformation.

Thank you
-Arun

Edited by: user626948 on Aug 28, 2008 10:40 PM
This post has been answered by ajochems on Aug 29 2008
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 29 2010
Added on Aug 29 2008
#business-process-management-suite, #soa-process-management
5 comments
12,073 views