Gini aja tgl_proses >= trunc(last_day(add_months(sysdate,-1))+1) and tgl_proses < trunc(sysdate); kalo prosesnya pagi hari sesudah jam 12.00 malem jadi gini aja tgl_proses >= trunc(last_day(add_months(sysdate-1,-1))+1) and tgl_proses < trunc(sysdate); coba deh semoga berhasil On 8/10/2010 11:25 PM, steve se 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] <mailto:lokerquota%40gmail.com>> > To: [email protected] <mailto: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]
