I am working with a table which saves the last_mod_date which the row in the database was updated. I am going to change this value for testing purposes, however i need to be able to enter back in the original date and time when i am finished testing. I have tried the statement below but it throws up an error "Arithmetic overflow during explicit conversion of VARCHAR value '18/01/2008 08:42:29.302' to a DATETIME field". Can anyone assist me in where i am going wrong.
set last_mod_user = 'user', last_mod_time = convert(char(23), '18/01/2008 08:42:27.302',109)
where id_inv = 123456