Saya coba bantu yah, ini function yg saya gunakan
untuk cari hari kerja saja dengan catatan ada table
untuk data tanggal2 libur nasional sebagai pembanding.
CREATE OR REPLACE FUNCTION DAYS_BETWEEN (p_start_date
DATE, p_end_date DATE)
RETURN NUMBER
IS
v_days NUMBER DEFAULT 0;
v_date DATE;
v_lbr NUMBER DEFAULT 0;
v_hasil NUMBER DEFAULT 0;
BEGIN
v_date := p_start_date;
WHILE v_date <= p_end_date
LOOP
IF TRIM(TO_CHAR (v_date, 'Dy')) <> 'Sun'
AND TRIM(TO_CHAR (v_date, 'Dy')) <> 'Sat'
AND TRIM(TO_CHAR (v_date, 'Dy')) <> 'Sab'
AND TRIM(TO_CHAR (v_date, 'Dy')) <> 'Ming'
THEN
v_days := v_days + 1;
END IF;
SELECT COUNT (*)
INTO v_hasil
FROM Tabel_lbr
WHERE TRUNC(tanggal) = TRUNC(v_date);
IF v_hasil > 0 THEN
v_lbr := v_lbr + 1;
END IF;
v_date := v_date + 1;
END LOOP;
v_days := v_days - v_lbr - 1;
RETURN v_days;
END;
Semoga membantu :)
Andrew
--- daniel_d <[EMAIL PROTECTED]> wrote:
> Saya sedang coba di dua versi 8.1.7 dan 10.1.0.3
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
-----------------------------------------------
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/
