Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 55 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Business requirement to convert PST time to UTC time in collaboration messaging
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
Answers
-
@Kamal Raj , Welcome to the Oracle Analytics Community!
I do not think this question has anything to do with Oracle Analytics. You might be well served if you can put the question in Oracle Customer Connect. - Welcome to Cloud Customer Connect. Thanks
0
