Have read in this forum to find a solution to convert timestamp. I found on jsonata homepage to get Day,Month and year nicely formatted but I have no luck with the time.
I just want HH:MM:SS from a ms timestamp.
If i use JSONata expression $now() I get this result 2020-01-14T22:17:17.823Z but I just want 22:17:17.
my solution is to use something like this $substring("????", 11, 18)
but I don't understand how I should combine $substring with $now()