Skip to content

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.

Translate to de es fr it pt ja