create table a ( end_date date, start_date date );
insert into a values ( '10-FEB-2000', '02-JAN-1999' );
insert into a values ( '02-FEB-2000', '10-JAN-1999' );
insert into a values ( '28-MAR-1996','28-FEB-1994' );
select months_between( end_date, start_date ),
trunc( months_between( end_date, start_date ) /12 ) tahun,
mod( trunc( months_between( end_date, start_date ) ), 12 ) bulan,
greatest(0,end_date - add_months(start_date,trunc( months_between(
end_date, start_date ) ))) hari
from a
/
TAHUN BULAN HARI
----- ----- ----
1 1 8
1 0 23
2 1 0
Semoga membantu.
Salam,
Indra Armansyah
[EMAIL PROTECTED]
----- Original Message -----
From: cipta
To: [email protected]
Sent: Monday, April 02, 2007 12:18 PM
Subject: [indo-oracle] Tanya algoritma
salam kenal,
saya ada kesulitan neh, gimn algoritma cara dapetin umur dengan
keterangan tahun, bulan, dan harinya dengan menggunakan PL/SQL. misal
: 22 thn, 11 bulan, 1 hari...
tolong yah
^_^
------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.24/742 - Release Date: 4/1/2007
8:49 PM
[Non-text portions of this message have been removed]
