Update rows that have incorrect date/time to correct date/time format

  datetime, mysql, php

I’ve been saving the date/time values as basic dates like:

11/22/2021 03:29:58 PM

I realized now that the application is growing, that was a huge mistake… Sadly I have over 300 rows that need to be changed to the correct formatting (ie: 0000-00-00 00:00:00)

Is there an easy way to do this? I tried searching everywhere

I don’t need any coding examples, just an explanation on where to look could be helpful

Source: Ask PHP

LEAVE A COMMENT