regex - Find and replace with reordered date format in notepad++ -

i have file few thousand rows added mysql database. there date values in rows in dd-mm-yyyy format need them in yyyy-mm-dd format.

e.g., '11-04-2010', needs become '2010-04-11', in every row.

is there simple way in notepad++ or text editor?

you can textpad:

find: ([0-9]+)-+([0-9]+)-+([0-9]+)

replace: \3-\2-\1