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 - Disaster Recovery (DR) Validation: End-to-End Test Scenarios

 1. Introduction Disaster Recovery (DR) is an important aspect of any enterprise integration platform. Organizations rely on Oracle Integra...