Bisadicoba pak sql-nya
select
trunc(months_between(sysdate,to_date('24jan1951','ddmonyyyy'))/12) umur from
dual
select
(months_between(to_date('01feb2007','ddmonyyyy'),to_date('01jun1996','ddmonyyyy'))/12)
masa_kerja from dual
thanks& Regards
-----Original Message-----
From: [EMAIL PROTECTED]:[EMAIL PROTECTED] OnBehalf Of agus purwanto
Sent: Wednesday, May 09, 200712:29 PM
To: [email protected]
Cc:[EMAIL PROTECTED]
Subject: [indo-oracle] Hitung umur
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]
---------------------------------
Ahhh...imagining that irresistible "new car" smell?
Check outnew cars at Yahoo! Autos.
[Non-text portions of this message have been removed]
