saya coba :
jam2:= to_char(to_date('19:00','HH24:MI')+(1/1440*15),'HH24:MI') ;
semoga membantu.
-----Original Message-----
From: "OLA" <[email protected]>
To: <[email protected]>
Date: Tue, 6 Oct 2009 14:02:42 +0700
Subject: [indo-oracle] hitung jam
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]
