How to Convert Timestamp from 1 min to 5 min
we have the number of rows divided by 1 min each
“2023-04-01 12:00:00 UTC”
“2023-04-01 12:01:00 UTC”
“2023-04-01 12:02:00 UTC”
“2023-04-01 12:03:00 UTC”
“2023-04-01 12:04:00 UTC”
“2023-...
Forum Discussion
Hi @vaidyarm
If you just want to filter the records where time is multiple of 5, then may be you can use below expression the filter snap:
Date.parse($inputDate.substring(0,19)).getMinutes() != 0 && Date.parse($inputDate.substring(0,19)).getMinutes() % 5 == 0
Output will look like this:
I hope this helps 🙂
