Additional Functions to support timestamps and unique ids about jsonata HOT 9 CLOSED

This will be a useful addition -- thanks for that.

I am wondering about the names of the functions, however. Often with a pair of inverse functions like this, one will be named "toXXX", and the other will be "fromXXX". As the terms "date" and "time" are so overloaded, and "ISO8601" is specific but ugly and hard to type, I would suggest $toMillis(date) and $fromMillis(number) maybe?

from jsonata.

Function $millis() has been added to branch 1.3. This returns the number of milliseconds since the epoch. In common with $now(), this function returns the same value for every invocation within a single expression.

from jsonata.

Andrew, the $millis() function is a nice addition - thanks for that.

Seems like the other missing piece is a way to get the ISO 8601 formatted date string from this number of millis. Is that in the plans as well?

from jsonata.

It certainly occupies my thoughts, and I'd want to make sure that it fits in with the wider requirement on string/number/date/time formatting captured in issue #54.

from jsonata.

Hi Andrew,

We actually have requirement to be able to convert in both directions, i.e.:

• millis -> ISO 8601 formatted data
• ISO 8601 formatted data -> millis

Are both being considered for inclusion in JSONata?

from jsonata.

The functions $toMillis() (ISO 8601 to millis) and $toDateTime() (millis to ISO 8601) have been added to the branch convert_timestamps as a consideration for 1.4

from jsonata.

@shrickus Good idea; I wasn't happy with $toDateTime() but it was certainly better than $toISO8601()... I've now updated the branch with the new function name.

from jsonata.

That branch has now been merged in with the 1.4 branch for release alongside the other new functions and changes in that.

As mentioned elsewhere, you can now play around with branch 1.4 (or any branch) in the exerciser by typing
J:branch 1.4
in the JSONata block in the top-right and pressing return

from jsonata.

toMillis() & fromMillis() now released in v.14

from jsonata.