hitung umur bisa pake query dibawah ini: SELECT ROUND(MONTHS_BETWEEN(tgl_keluar,tgl_lahir)/12) FROM DUAL.
masa kerja : SELECT ROUND((MONTHS_BETWEEN(tgl_keluar,tgl_mulai_kerja)/12),2) FROM DUAL CMIIW On 5/9/07, agus purwanto <[EMAIL PROTECTED]> wrote: > > salam, > > saya punya data, > tgl lahir = 24 jan 1951 > tgl mulai kerja=1 jun 1996 > tgl keluar = 1 feb 2007 > > bagaimana cara nya menampilkan data seperti ini > umur = 56 > masa kerja = 10,67 thn (10 thn 8 bulan) > > terima kasih, > ags > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > [Non-text portions of this message have been removed] > > > -- Regards, Edi Yanto PT. Jati Piranti Solusindo (Jatis Solutions) Menara Jamsostek, Tower A, 16th floor Jl. Jend. Gatot Subroto Kav.# 38 Jakarta Selatan, 12930 - Indonesia my blog: http://ediyanto83.wordpress.com [Non-text portions of this message have been removed]
