Ada yang tahu perbedaannya dan solusi masalah di bawah ini?? query saya,
SELECT COUNT(*) FROM my_table WHERE TO_CHAR(date_time, 'DD/MM/YYYY') BETWEEN '01/10/2007' AND '06/11/2007' >> Result : 4152021 dan SELECT COUNT(*) FROM my_table WHERE TO_CHAR(date_time, 'DD/MM/YYYY') BETWEEN '01/10/2007' AND '6/11/2007' >> Result : 4152021 menurut saya, tidak ada perbedaan dalam query tersebut. ada yang bisa menambahkan?? Environment: Oracle : 9i R2 Enterprise Edition dan 10g R2 Enterprise Edition TOAD : Toad for Oracle 8.6.0.38 regard, subekti ----- Original Message ----- From: Harry Christian To: [EMAIL PROTECTED] Sent: Monday, November 05, 2007 2:20 PM Subject: (newbie_hacker) Query Oracle aneh (bugs atau apa ya ?) 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' The different is, the 1st query use 6-11-2007 instead of 06/11/2007. FYI, i use Oracle database 9i and running query in Toad for Oracle 8.5.3.2 Any idea why this can happen ? Ada rekan2 yg tau ga kenapa bisa begitu ? -- ============================== Thanks & Best Regards Harry Christian YM : callme_harry G Talk : [EMAIL PROTECTED] MSN : [EMAIL PROTECTED] Skype : harry_christian Friendster : http://www.friendster.com/addfriendrequest.php?uid=5590705 Blog : http://www.harry-christian.blogspot.com =============================== [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
