How to add and subtract fom time in MySQL

Luckily for us there is an ADDTIME function we can use to add and remove from times… The syntax is as follows: ADDTIME(datetime,time_to_change) example

SELECT `emp_id` , `clock_time` , ADDTIME( '-01:00:00', `clock_time` ) AS new_time
FROM `timeclock`

Will return

emp_id clock_time new_time
10059 08:30:55 07:30:55
10059 08:31:06 07:31:06
10059 08:31:28 07:31:28
10046 08:33:44 07:33:44

An Update example

UPDATE `timeclock` SET `clock_time` = ADDTIME( '-01:00:00', `clock_time` ) WHERE `id` BETWEEN 40967 AND 41022

Leave a Reply

Close Menu
%d bloggers like this: