Coba ini deh bro... tinggal tambahin create function sama date_in n date_out
jadi parameter
DECLARE
DATE_IN DATE;
DATE_OUT DATE;
TOTAL_DAY NUMBER;
TOTAL NUMBER;
DATE_COUNTER DATE;
BEGIN
TOTAL := 0;
DATE_IN := TO_DATE ('12-05-2005','DD-MM-YYYY');
DATE_OUT := TO_DATE ('12-05-2006','DD-MM-YYYY');
-- Hitung Jumlah hari antara 2 tanggal
TOTAL_DAY := DATE_OUT - DATE_IN;
-- Counter Untuk menghitung jika bukan hari minggu atau senin
FOR I IN 0..TOTAL_DAY LOOP
DATE_COUNTER := DATE_IN + I;
IF TO_CHAR (DATE_COUNTER,'DAY') NOT LIKE '%MONDAY%' AND
TO_CHAR (DATE_COUNTER,'DAY')NOT LIKE '%SUNDAY%' THEN
TOTAL:= TOTAL + 1;
END IF;
END LOOP;
DBMS_OUTPUT.PUT_LINE(TOTAL);
END;
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf Of Agus Sukayat
Sent: Tuesday, August 30, 2005 2:54 PM
To: [email protected]
Subject: [indo-oracle] MENGHITUNG HARI
Siang pakar2 oracle,
Saya lagi ada sedikit masalah,bgmn bikin function yang menghasilkan nilai
sbb : Jika saya masukan tgl_awal 1-aug-2005 dan tgl_akhir 25-aug-2005 maka
saya akan tahu nilai tgl_akhir-tgl_awal = .... tapi untuk hari sabtu n
minggunya tidak dimasukan dalam proses perhitungan.
Ada yang tahu bgm bikin function tsb????
Makasih atas bantuannya.
Agus Sukayat
[Non-text portions of this message have been removed]
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/PhFolB/TM
--------------------------------------------------------------------~->
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
