Mas coba pake sintax ini
SELECT TRUNC((tglselesai-tglorder)*24) ||' JAM ' || TRUNC(((tglselesa-tglorder)*24-TRUNC((tglselesa-tglorder)*24))*60) || ' MENIT ' FROM table a Smoga bsa membantu (mesqi rada panjang) Ones _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of agus sulaiman Sent: Thursday, September 13, 2007 7:59 AM To: [email protected] Subject: [indo-oracle] Menghitung selisih jam pada sql Kepada Teman-teman semuanya, Bagaimana cara menghitung selisih jam misalkan kita ada field tglorder dan tglselesai. biasanya kalo untuk mengetahui selisih hari kita bisa menggunakkan tanda minus.nah bagaimana bila kita ingin mengetahui selisih jam? saya sudah mencoba denagn cara : select to_char(tglselesai,-'hh24:mi:-ss') - to_char(tglorder,-'hh24:mi:-ss) from table a; tapi hasil adalah error invalid number. mungkin teman-teman sudah pernah ada yang mencobanya. Terima kasih. Salam, Agus. mungkin teman-teman bisa ------------------------------------ Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more. [Non-text portions of this message have been removed] -- Internal Virus Database is out-of-date. Checked by AVG Free Edition. Version: 0.0.441 / Virus Database: 268.18.8/718 - Release Date: 3/11/2007 9:27 AM -- Internal Virus Database is out-of-date. Checked by AVG Free Edition. Version: 0.0.441 / Virus Database: 268.18.8/718 - Release Date: 3/11/2007 9:27 AM [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
