atau bisa : select sysdate + 15/1440 from dual
On Tue, Oct 6, 2009 at 3:28 PM, fikril <[email protected]> wrote:
> coba function ini :
>
> CREATE OR REPLACE FUNCTION Hit_jam(awal in date default sysdate,akhir in
> date default sysdate) RETURN VARCHAR2 is
>
> total_dtk_akhir number;
> total_dtk_awal number;
> total_dtk number;
> jam number;
> mnt1 number;
> mnt number;
> dtk number;
> beda varchar2(200);
> Begin
>
>
> total_dtk_akhir:=(to_number(to_char(akhir,'hh24'))*60*60)+(to_number(to_char(akhir,'mi'))*60)+
> (to_number(to_char(akhir,'ss')));
>
> total_dtk_awal:=(to_number(to_char(awal,'hh24'))*60*60)+(to_number(to_char(awal,'mi'))*60)+
> (to_number(to_char(awal,'ss')));
> total_dtk:=total_dtk_akhir - total_dtk_awal;
> jam :=trunc(total_dtk/3600);
> mnt1:=total_dtk-(jam*3600);
> mnt :=trunc(mnt1/60);
> dtk :=total_dtk-((jam*3600)+(mnt*60));
> beda:=jam||' Jam '||mnt||' Menit '||dtk||' Detik';
>
>
> return(beda);
> Exception
> when others then dbms_output.put_line(sqlerrm);
> End;
> /
>
> contoh input :
>
> select
> hit_jam(to_date('09:10:15','HH24:MI:SS'),to_date('12:15:14','HH24:MI:SS'))
> from dual
>
>
> Salam
> Fikril
>
> 2009/10/6 OLA <[email protected]>
>
>
>>
>> minta bantuan rekan2 mengenai perhitugan jam
>> kalo ada variabel
>>
>> begin
>> jam := '19:00'; -- varchar2
>> jam2 := jam + 15 -- maksudnya di tambah 15 menit
>> end ;
>>
>> bagaimana solusinya
>> sedangkan 15 menit ada suaru default dan variabel jam bisa berganti2
>>
>> thx atas perhatiannya
>>
>> Ola
>>
>> [Non-text portions of this message have been removed]
>>
>>
>>
>
>
[Non-text portions of this message have been removed]
