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]
