yang betul tuh
SELECT COUNT(*)
FROM my_table
WHERE TO_DATE(date_time, 'DD/MM/YYYY') BETWEEN TO_DATE('01/10/2007'
,'DD/MM/YYYY') AND TO_DATE('06/11/2007','DD/MM/YYYY')
Yulius Wibowo <[EMAIL PROTECTED]> wrote:
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]
>
Best Regard
Miftahul Huda
+6281330454181
__________________________________________________
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]
