update DOSEN_FAKULTAS_EKONOMI set tgllahir=
concat('19',right(tgllahir,2),'-',
case 
when substring(tgllahir,4,3)='Jan' then '01'
when substring(tgllahir,4,3)='Feb' then '02'
when substring(tgllahir,4,3)='Mar' then '03'
when substring(tgllahir,4,3)='Apr' then '04'
when substring(tgllahir,4,3)='Mei' then '05'
when substring(tgllahir,4,3)='Jun' then '06'
when substring(tgllahir,4,3)='Jul' then '07'
when substring(tgllahir,4,3)='Agu' then '08'
when substring(tgllahir,4,3)='Sep' then '09'
when substring(tgllahir,4,3)='Okt' then '10'
when substring(tgllahir,4,3)='Nop' then '11'
when substring(tgllahir,4,3)='Des' then '12'
when substring(tgllahir,4,3)='Peb' then '02'
when substring(tgllahir,4,3)='Nov' then '11'
when substring(tgllahir,4,3)='Aug' then '08'
when substring(tgllahir,4,3)='Oct' then '10'
when substring(tgllahir,4,3)='May' then '05'
when substring(tgllahir,4,3)='Dec' then '12'
end,'-',
left(tgllahir,2))