hallo all,
untuk comparasi tanggal dengan to_char (string), coba format
'YYYY-MM-DD', sepertinya lebih aman.
personal preference, saya lebih suka membuat kriteria nya
WHERE date_time between TO_DATE('') and TO_DATE('')
alasan: index di kolom date_time jadi bermanfaat, index yang ada (dan
seharus nya ada) kan untuk nilai date_time, bukan to_char(date_time).
full table scanning is nightmare!
cautions: di dbms yang ga punya tipe data date, tapi punya nya
datetime, kriteria saya bisa buggy (issue: nilai time nya)
apakah query mas Harry ini menunjukkan bug Oracle ? hmm .. kalau
datanya tidak terlalu banyak (result set nya), bisa di munculkan
disini gak mas result set yang diinginkan (hasil query 1)
tri
--- In [email protected], "Harry Christian" <[EMAIL PROTECTED]> wrote:
>
> Kemarin saya sudah berkeluh kesah di blog saya
> http://harry-christian.blogspot.com/2007/11/bugs-in-oracle-query.html
> saya paste aja ya
>
> I want to query a data with date condition. Guess what ? This
similiar query
> give a different result.
>
> 1st query give the exact result that i wanted.
> SELECT * FROM my_table
> WHERE TO_CHAR(date_time, 'DD/MM/YYYY') BETWEEN '01/10/2007' and
'6/11/2007'
>
> 2nd query result nothing
> SELECT * FROM my_table
> WHERE TO_CHAR(date_time, 'DD/MM/YYYY') BETWEEN '01/10/2007' and
'06/11/2007'
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> 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/
