Thank's atas bantuannya n udah OK ________________________________
From: [email protected] on behalf of Addino Yudi Sent: Tue 8/30/2005 4:41 PM To: [email protected] Subject: RE: [indo-oracle] MENGHITUNG HARI 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 -- -----------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 [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/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/
