Coba pakai
create or replace function jumlah_hari (tanggal date) return number as
dtawal date;
dtakhir date;
begin
dtawal := tanggal-to_number(to_char(tanggal,'dd'))+1;
dtakhir:=add_months(dtawal,1)-1;
return to_number(to_char(dtakhir,'dd'));
exception
when others then
raise_application_error('-20000',sqlerrm);
end;
select jumlah_hari(sysdate) from dual
--- On Fri, 4/18/08, Lutfi hedir <[EMAIL PROTECTED]> wrote:
> From: Lutfi hedir <[EMAIL PROTECTED]>
> Subject: [indo-oracle] query memperoleh jumlah hari dari bulan
> To: [email protected]
> Date: Friday, April 18, 2008, 8:51 AM
> Selamat Pagi Indo-Oracle
>
> ada yang bisa bantu cara mengetahui jumlah hari dalam satu
> bulan,
> contoh kita tahu date='12-12-2009' maka keluar
> desember 30 hari?
>
> terima kasih
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
