Oke mas bro ternyata bisa, Thanks
On Tue, Aug 10, 2010 at 11:25 PM, steve se <[email protected]> wrote: > > > > coba pakai select trunc(sysdate,'month') from dual atau select > last_day(last_day(sysdate)-32)+1 from dual; > > ________________________________ > From: Kusuma D <[email protected] <lokerquota%40gmail.com>> > To: [email protected] <indo-oracle%40yahoogroups.com> > Sent: Tue, August 10, 2010 3:04:25 PM > Subject: [indo-oracle] Tanya script buat tgl awal bulan > > > para master nubi mau tanya nih script buat > tanggal biar otomatis gimana y , tidak ganti tgl awal > ex : tgl_proses between '01aug10' and trunc(sysdate) > bagaimana supaya yg tanggal awal itu selalu baca tanggal 1 setiap bulannya, > biar tidak merubah setiap bulannya > > Mohon pencerahan, > tks, > > [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]
