coba pakai select trunc(sysdate,'month') from dual atau select last_day(last_day(sysdate)-32)+1 from dual;
________________________________ From: Kusuma D <[email protected]> To: [email protected] 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]
