SQL changing DD-MM-YYYY to YYYY-MM-DD in two existing columns

Viewed 24

I have two columns in one table both containing a mix of DD-MM-YYYY and YYYY-MM-DD formatting. The cells with the YYYY-MM-DD are correct, but I want to update the DD-MM-YYYY cells to the same format. What query do I use?

Can't get it to work.

0 Answers
Related