$formatDateTime(millis, picture [, timezone]) and $parseDateTime(timestamp, picture) about jsonata HOT 1 OPEN

$formatDateTime() was not implemented as a separate function, but on $toMillis (and its equivalent in $fromMillis()) as you've spotted.

It looks like we might have a bug with regardless to an uppercase month; I believe the picture string should be [MN] in that case.

If you have $toMillis('10/May/2018', '[D]/[MNn]/[Y]') then you get 1525910400000 as expected, but $toMillis('10/MAY/2018', '[D]/[MN]/[Y]') doesn't work (and oddly using May with [MN] does)

If I then add on ~> $fromMillis('[D]-[MN]-[Y]') then I get 10-MAY-2018 so the picture string works correctly on that end.

As a workaround for now you might need to adjust your date before using $toMillis().

from jsonata.