I ams torign a date in a mysql db it is inputted as DD/MM/YYYY and i need to transform it to YYYY/MM/DD then also swith it back to DD/MM/YYYY

Anyone got a fucntion that could help me ?