Useful SQL commands - Fastaval/Infosys GitHub Wiki

Updating GDS dates

update gdsvagter set slut = adddate(slut, interval -9 day);
update gdsvagter set slut = adddate(slut, interval 1 year);
update gdsvagter set start = adddate(start, interval -9 day);
update gdsvagter set start = adddate(start, interval 1 year);

Updating Indgang dates

update indgang set start = adddate(start, interval -9 day);
update indgang set start = adddate(start, interval 1 year);

Updating madtider dates

update madtider set dato = adddate(dato, interval -9 day);
update madtider set dato = adddate(dato, interval 1 year);