select * from tb_kgb where jenjang='3' and ( (DATE_FORMAT(tmt_kgb_baru,'%Y')='2026' and DATE_FORMAT(tmt_kgb_baru,'%m')='04') ||
((DATE_FORMAT(tmt_kgb_baru,'%Y')='2026') and DATE_FORMAT(tmt_kgb_baru,'%m')='05') ||
((DATE_FORMAT(tmt_kgb_baru,'%Y')='2026') and DATE_FORMAT(tmt_kgb_baru,'%m')='06')) and acc_dinas='0' and aktif='1'-
Verifikasi KGB : Dinas Pendidikan, Kepemudaan, dan Olahraga (1) Jenjang SMP
No
Nama/NIP/Pagol/Instansi
TMT/MK KGB Lama TMT/MK KGB Baru Countdown
Menu
Ket
select * from tb_kgb where jenjang='3' and ( (DATE_FORMAT(tmt_kgb_baru,'%Y')='2026' and DATE_FORMAT(tmt_kgb_baru,'%m')='04') ||
((DATE_FORMAT(tmt_kgb_baru,'%Y')='2026') and DATE_FORMAT(tmt_kgb_baru,'%m')='05') ||
((DATE_FORMAT(tmt_kgb_baru,'%Y')='2026') and DATE_FORMAT(tmt_kgb_baru,'%m')='06')) and acc_dinas='0' and aktif='1' order by tmt_kgb_lama LIMIT 0,10
1
JOKO SULISTYA, M.Pd., M.Hum. (51 th 7 bln)
197408132005011008 Pembina Tk.1, IV/b15 -> 15 SMP NEGERI 3 BANTUL
Jenis Kepegawaian : PNS PEMDA Jenis Jabatan : JFT PENDIDIK