terima kasih semuanya..
saya udah ketemu dan sudah saya modif dari jawaban pak
indra ini :)
Thanks yach...
======================================================
--- Indra Armansyah <[EMAIL PROTECTED]> wrote:
> create table waktu ( waktu1 date, waktu2 date);
>
> insert into waktu values(to_date('24-07-2006
> 09:30:00','DD-MM-YYYY
> HH24:MI:SS'),
> to_date('26-07-2006 10:30:00','DD-MM-YYYY
> HH24:MI:SS'));
>
> >> Selisih jam dengan mengabaikan tanggal:
> select ((waktu2 - waktu1) - (to_date(waktu2) -
> to_date(waktu1))) * 24
> selisih
> from waktu;
>
> SELISIH_JAM
> -----------
> 1
>
> >> Selisih jam dengan tanpa mengabaikan tanggal
>
> select (waktu2 - waktu1) * 24 selisih_jam
> from waktu;
>
> SELISIH_JAM
> -----------
> 49
>
>
> Salam,
>
> Indra Armansyah
> [EMAIL PROTECTED]
>
> ----- Original Message -----
> From: "chiank" <[EMAIL PROTECTED]>
> To: <[email protected]>
> Sent: Wednesday, July 26, 2006 10:36 AM
> Subject: Re: [indo-oracle] Fungsi untuk Mengurangi
> time
>
>
> > On 7/26/06, jimmy <[EMAIL PROTECTED]> wrote:
> >> Dear all,
> >> Ada gak ya, function di oracle, untuk mengambil
> >> selisih dari waktu.
> >> Misalkan : 24/07/2006 09:30:00
> >> dengan
> >> 26/07/2006 10:30:00
> >>
> >> kita mendapatkan selisihnya adalah 01:00:00
> >>
> >> dimana tanggalnya kita abaikan saja.
> >> saya mau mengambil nilai selisih dari waktu/time
> nya
> >> saja.
> >
> > ini ide mentahnya...
> >
> > SELECT TO_CHAR(SYSDATE,'DD-MM-YYYY HH:MI:SS') FROM
> DUAL ;
> > SELECT TO_CHAR(trunc(sysdate+1) + 8/24,'DD-MM-YYYY
> HH:MI:SS') from dual ;
> > SELECT TO_CHAR(SYSDATE,'HHMISS') -
> TO_CHAR(trunc(sysdate) +
> > 8/24,'HHMISS') from dual ;
> >
> > silakan di kembangkan sesuai keinginan anda..
> >
> > --
> >
> > chiank
> >
> >
> >
> > --
> > -----------I.N.D.O - O.R.A.C.L.E---------------
> > Keluar: [EMAIL PROTECTED]
> > Website: http://indo-oracle.blogspot.com
> > Mirror: 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
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > --
> > No virus found in this incoming message.
> > Checked by AVG Free Edition.
> > Version: 7.1.394 / Virus Database: 268.10.4/399 -
> Release Date: 7/25/2006
> >
> >
>
>
__________________________________________________
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
Mirror: 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/
<*> 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/
