Business requirement to convert PST time to UTC time in collaboration messaging

Kamal Raj

one of the vender using collaboration messaging to post the ASN IN messages. They have special requirement to convert date time from PST to UTC time zone.

They suggested to use this in collaboration messaging

<xsl:variable name="UTC-date" select="substring-before(adjust-dateTime-to-timezone(dateTime(concat(/cmk:processInboundCollaborationMessage/cmk:InboundCollaborationMessage/oa:ProcessShipment/oa:DataArea/oa:Shipment/oa:ShipmentHeader/oa:DocumentDateTime,'-07:00')),dayTimeDuration('PT0S')),'Z')"/>

 but we need current pst offset in place hard code value of -07:00 or -08:00 (by considering daylight savings). So how to get current pst offset by using xslt function

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/28068/business-requirement-to-convert-pst-time-to-utc-time-in-collaboration-messaging

Hi @Kamal Raj,

Welcome to the Oracle Analytics community!

Please note this Community is for Oracle Analytics Tools.

Here's a post which might be useful for you.

Collaboration messaging framework XML customization — Cloud Customer Connect

Hope this help.

Thank you.

Bhaskar Konar

Hi @Kamal Raj,

Additionally, following community might be better place to raise your question as that will get expert suggestions quickly & easily.

Receivables & Collections — Cloud Customer Connect

Hope this help.

Thank you.

Kamal Raj

Thank you @Bhaskar Konar