Komparasi di BETWEEN..AND-nya pakai 'character', bukan DATE, karena sudah di TO_CHAR-kan...
CMIIW, Bw --- In [email protected], "Subekti Pranoto" <[EMAIL PROTECTED]> wrote: > > 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] >
