My date time format is as following:
Apr 28 09:27:01
How do I do the math please? For example, I wanna find out date time 5 minutes before the above date. In MySQL datetime format is 2018-04-28 09:27:01 and the math function to get 5 minutes earlier is:
DATE_SUB(‘2018-04-28 09:27:01’, INTERVAL 5 MINUTE)
Do you have similar function I can use please?
Sorry if my question is too newbie.