coba yg ini deh,,
select round(months_BETWEEN(sysdate,To_date(TGL_LAHIR))/12) "Umur",
round(months_BETWEEN(TGL_KELUAR,TGL_MASUK))/12)
||' tahun '||
round((months_BETWEEN(TGL_KELUAR,TGL_MASUK) -
round(months_between(TGL_KELUAR,TGL_MASUK)/12)*12))
||' bulan' "Masa Kerja"
from NAMA_TABLE
tapi sepertinya ada yg lebih baik dari ini,
CMIIW
firman
2007/5/9, agus purwanto <[EMAIL PROTECTED]>:
>
> 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]
>
>
>
--
Firman HM
PT. Xsis Mitra Utama
Graha BIP 7th Floor Jl. Jend. Gatot Subroto Kav.23 Jakarta 12930 -
Indonesia
Tel : +62-21-5210565 Hotline : +62-21-5210564 Fax : +62-21-5229777
[Non-text portions of this message have been removed]
