Comments (9)
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.
Related Issues (20)
- How to return the value from jsonata instead of promise/async HOT 3
- Dry run, return expected schema for a given input schema
- How to handle undefined value HOT 2
- $formatDateTime(millis, picture [, timezone]) and $parseDateTime(timestamp, picture) HOT 1
- Clarification : Is there Any Feature for Apply Break or Continue in Looping HOT 1
- parallel map
- switch case or if else
- Truthiness of numbers is completely random
- Help resolve current pinning to 1.8.6 for JSONata-Wrapper (possibly ducktape compatibility)
- Reserved Tokens Documentation
- ($.some_non_existent_key != 'anything') evaluates to false HOT 3
- $string(number) capped at precision-15
- Error handling and asynchronous behavior in evaluate function
- Rounding number without "Round half to even"
- There isn't a uuid() function for JSONata HOT 2
- Hard spaces in documentation not rendered correctly
- Security contact for JSONata HOT 4
- default query on try.jsonata.org HOT 1
- is 2.0.4 a fake release? HOT 4
- Multi-level JSON processing: Unwrapping Objects
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from jsonata.