howto - add one second / add time to a date column
Nothing much to write. You want to add a second or some time to an available column.
-- add a second to current time
ADDTIME(`my_table`.`my_date_field`, '00:00:01')
Want to know more? Check the available man page about time and date at mysql.com.