select distinct(month) month from (select to_date(to_char(daftar,'mon'),'mon') month from tbA)
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of AnRof Rawnan Sent: Wednesday, 12 March, 2008 11:01 AM To: [email protected] Subject: Re: [indo-oracle] create list month 2008/3/12 Antonius Bayu <[EMAIL PROTECTED] <mailto:bayu_9484%40yahoo.com> >: > Pak,mungkin anda bisa menggunakan query ini > SELECT TO_CHAR(daftar,'YYYYMM') > FROM tbA > GROUP BY TO_CHAR(daftar,'YYYYMM') > ORDER BY TO_CHAR(daftar,'YYYYMM') > > CMIIW > > Regards, > > Antonius Bayu > > Dear, Bukannya itu hanya menampilkan bulan yang ada di record tersebut?? jadi yang bulan maret tidak ada.. CMIIW -- YM_id : muh_ilman_a http://misisawa.blogspot.com <http://misisawa.blogspot.com> http://anrof.myminicity.com/ <http://anrof.myminicity.com/> [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
