From "dd/MM/yyyy" to "yyyy-MM-dd": s/^(\d+)-(\d+)-(\d+)$/$3-$2-$1/ id | date id | num ---|----------- ---|----------- 1 | 14-01-2003 1 | 2003-01-14 ---|----------- ---|----------- 2 | 28-07-2004 2 | 2004-07-28 ---|----------- ---|----------- 3 | 08-11-2005 3 | 2005-11-08