I have a DB field type datetime in which there are some dates, like:
I now want to change all the dates to the following one:
But simply dont know how the update query looks like.
Table is imagefound, column is first_found
Anybody who can help?