How to format/get dateTime to NEXT full hour? (e.g. 6:40pm 12 seconds to 7.00 pm) in Server Connect only (not front end)

Hi guys,

I’m trying to format (in UTC) a dateTime insert / update to the next hour.

E.g. if it’s currently 05.43.32 (hour-minute-seconds) I’d like to format current dateTime’s time to 06.00.00.

I’m sure it’s possible, so wondering if anyone has any ideas/solutions for this?

I’m using Node/MariaDB.


Community Page
Last updated: