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!

xp20:format-dateTime('060111','[Y01][M01][D01]') returns null...

480843Jan 15 2006 — edited Jan 25 2006
As part of my tranformation I need to convert a date string into a datetime type. This operation kept returning null so I decided to hard code the value and the result is still null. Can anyone provide any insight?

XSL TRANFORMATION:
<order:OrderHdrAction>
<xsl:text disable-output-escaping="no">ADD
</xsl:text>
</order:OrderHdrAction>
<order:OrderHdrReqdt>
<xsl:value-of select="xp20:format-dateTime('060111','[Y01][M01][D01]')"/>
</order:OrderHdrReqdt>
<order:OrderHdrPonum>
<xsl:value-of select="/client:adage_orderentry_qdb_processorProcessRequest/client:flat_order/imp1:instruction/imp1:po_num"/>
</order:OrderHdrPonum>

RESULTANT XML:
<order:OrderHdrAction xmlns:order="http://www.shamrockfoods.com/adage/orderentry">ADD</order:OrderHdrAction>
<order:OrderHdrReqdt xmlns:order="http://www.shamrockfoods.com/adage/orderentry" />
<order:OrderHdrPonum xmlns:order="http://www.shamrockfoods.com/adage/orderentry">00001234</order:OrderHdrPonum>
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 22 2006
Added on Jan 15 2006
1 comment
1,344 views