Maksudnya begini? add_months(trunc(sysdate,'mm'),-1)
2010/8/21 Kusuma D <[email protected]> > > > Nah kalo pengen yang bulan sebelumnya gimana y? > tapi range tanggal sama, > mis: 1-21 jul, tanpa harus ganti2 tanggalnya? > > Tks, > > 2010/8/11 syaiful arief <[email protected] <sarief_iqb%40yahoo.com>> > > > > > > > > pakek ini TRUNC(sysdate,'MM') > > > > tgl_proses >= TRUNC(sysdate,'MM') and tgl_proses < > > > trunc(sysdate) > > > > ________________________________ > > From: Kusuma D <[email protected] <lokerquota%40gmail.com><lokerquota% > 40gmail.com>> > > > To: [email protected] <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com> > > Sent: Wed, August 11, 2010 9:48:15 AM > > Subject: Re: [indo-oracle] Tanya script buat tgl awal bulan > > > > > > hehehe iya berhasil mbak , terima kasih > > > > On Wed, Aug 11, 2010 at 8:17 AM, marina > > <[email protected]<marina.christien%40gmail.com> > <marina.christien%40gmail.com>> > > > wrote: > > > > > > > > > > > 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] > > > > <lokerquota%40gmail.com><lokerquota% > 40gmail.com><lokerquota% > > > 40gmail.com> <mailto: > > > lokerquota%40gmail.com <lokerquota%2540gmail.com>>> > > > > To: [email protected] > > > > <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com><indo-oracle% > > > 40yahoogroups.com> <mailto: > > > indo-oracle%40yahoogroups.com <indo-oracle%2540yahoogroups.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] > > > > > > > > > > > > > [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] > > > -- Pelajari setiap bahasa pemrograman, karena engkau tidak akan tahu dari bahasa mana Allah menurunkan rezeki untukmu [Non-text portions of this message have been removed]
