ada 2 cara : 1. property di item nya diset sampai detik 2. dengan mengubah character spt to_char(sysdate,'dd/mm/rrrr hh24:mi:ss')
smoga membantu.. :) ________________________________ From: Ruben Edson <[email protected]> To: [email protected] Sent: Thu, November 26, 2009 3:38:11 PM Subject: [indo-oracle] Re: WTA: how to set datetime (now) in text item @ oracle form Thank's Ibu Marina dan Bapak Murdi... btw, klo utk menampilkan waktunya (jam, menit dan detik) jg, gmn? ____________ _________ _________ __ From: marina <marina.christien@ gmail.com> To: indo-oracle@ yahoogroups. com Sent: Thu, November 26, 2009 2:38:53 PM Subject: Re: [indo-oracle] WTA: how to set datetime (now) in text item @ oracle form Pak Ruben, kalau mau format tanggl yg panjang langsung saja gunakan tipe data datetime terus gak usah di kasi to_char. contoh :tgl_jual := sysdate; kalau mau menggunakan to_char ya tipe text itemnya haru char juga. semoga berhasil. Ruben Edson wrote: > > > Dear: All user indo-oracle > > bagaimana cara setting waktu di text item (:penjualan. tgl_jual) ketika > form pertama kali running? > > berikut ini codingnya: > saya buat trigger (When-New-Form Instance) di form > begin > select to_char(sysdate, 'Dy DD-Mon-YYYY HH24:MI:SS') into > :penjualan.tgl_ jual from dual; > end; > > dengan format field tgl_jual date, muncul error... > > mohon saran / masukan temans... Thanks a lot :D > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
