Wednesday, September 25, 2024

OIC - Need to format a dateTime object with a three character month

Requirement: We need to create a file name where we need to populate Month's name as MMM like Sep, Oct etc.


Solution:

fn:concat('HCM_FTE_',ns96:format-dateTime(fn:current-dateTime(),'[MNn,*-3]-[Y001]'),'.csv')

Note: for Caps month like SEP. OCT , use as [MN,*-3]

No comments:

Post a Comment

Featured Post

OIC - OIC Agent Health Check Service Using OIC Monitoring API

In many Oracle Integration Cloud (OIC) implementations, on-premise and hybrid integrations depend heavily on Connectivity Agents. If an agen...