Skip to Content

Dokter Salim Mulyana

Dokter dan Opreker

Home / 2017 / Oktober

Monthly Archives: Oktober 2017

Query Update Umur Pasien Di SIMRS Khanza

update pasien set umur=concat(timestampdiff(year, tgl_lahir, curdate()),’ Th ‘, timestampdiff(month, tgl_lahir, curdate()) mod 12, ‘ Bl ‘, timestampdiff(day, (tgl_lahir + interval (timestampdiff(month, tgl_lahir, curdate())) month) , curdate()), ‘ Hr’);