I want to convert my now() time to round down to nearest 10th minute.
If now returns 10:02 I want it to be converted to 10:00, if its, 10:18 then 10:10.
How can we achieve that?
| eval time=strftime((floor(now()/600))*600,"%Y-%m-%d %H:%M:%S")
Just adding on to @renjith.nair 's cddoe for minor time format issues
If the solutions above worked out, please accept the answer , otherwise let us know what is the remaining issue