Mule MEL Date Time Format

Question

I am trying to output data in DD-MON-YY(22-OCT-15) format to insert into an Oracle DB. I used the MEL expression server.dateTime.format("dd-MMM-yy"). This outputs data as 22-Oct-15. See fragment below.

<expression-component doc:name="Expression"><![CDATA[if ( flowVars.collection_opening_date == null){
    flowVars.collection_opening_date = server.dateTime.format("dd-MMM-yy");
}]]></expression-component>

There is no error from this snippet. server.dateTime.format("dd-MMM-yy") outputs as 22-Oct-15 and my desired format is 22-OCT-15. How can I get my desired format?

Can you explain your desired behaviour more please? And share more about what problem/error is ocurring. — kdbanman
There is no error server.dateTime.format("dd-MMM-yy") outputs as 22-Oct-15 and my desired format is 22-OCT-15. Is it possible via — hpandalai

Ryan Carter Ryan Carter · Accepted Answer · 2015-10-22T19:41:41

3

votes

Just uppercase it like so: server.dateTime.format("dd-MMM-yy").toUpperCase().

Mule MEL Date Time Format

1 Answers