Coba dengan 1 select query sbb :
select last_day(:P1)-
to_date('01-'||TO_CHAR(:P1,'MON-YYYY'),'DD-MON-YYYY')+1 JUMLAH_HARI
from dual;
Dimana :P1 merupakan variable bertipe date.
atau jika ingin menghitung jumlah hari kerja, dapat dilihat di sini :
http://orafind.com/pl-sql-tips-and-tricks/how-to-count-working-days-on-specific-date/
Semoga dapat membantu.
Totok Wicaksono <[EMAIL PROTECTED]> wrote: 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 wrote:
> From: Lutfi hedir
> 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.
[Non-text portions of this message have been removed]
