Sebelum segala bentuk query diterapkan, saya sarankan anda check terlebih
dahulu NLS_DATE_FORMAT pada Oracle.
Karena query date yang anda pakai menggunakan 'DD/MM/YYYY' maka set NLS_DATE
diatas menjadi 'DD/MM/YYYY' (seperti yang anda pakai) karena default format
NLS_DATE pada oracle yakni 'MM/DD/YYYY'. Saran saya lakukan sbb:
sql> alter session set nls_date_format = 'dd/mm/yyyy'
Tq... o)~ cheers
Kholeel Rahman
"Meru R. Harjono" <[EMAIL PROTECTED]> wrote:
Halo semua,
Saya mau menanyakan masalah query tanggal di oracle, saya ingin mengambil
data selama 1 bulan dengan menggunakan format mm/yyyy. Jadi saya coba
memakai query:
select distinct to_char(a.date_of_record,'dd/mm/yyyy') as
date_of_record,a.id,b.send
>From report_p a, transmitter_p b
Where a.id = b.id and to_char(date_of_record,'mm/yyyy') = ('01/2005')
Tapi querynya jadi jauh lebih lambat dibandingkan kalo pake range tanggal
secara langsung. Mungkin ada yang bisa membantu mengoptimalkan query ini.
Terimakasih banyak
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
