Skip to Main Content

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!

Convert String to Date using XPATH

661862Jan 22 2011 — edited Feb 27 2020
We are using Transform Activity to map source(String) to Target(Date) column.
We have a requirement where we need to convert string (MM/DD/YYYY) to Date(MM/DD/YYYY HH.MM.SS AM) format.

For example: If source column have a value *9/13/2004*...then we want to populate *9/13/2004 12:00:00 AM*.

Can some one suggest how to achieve this using xsl/xpath??

Thanks,
AB
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 24 2011
Added on Jan 22 2011
4 comments
6,382 views