Because in the second select, you are using the wrong mask. Try 'mmyy'.
> -----Original Message-----
> From: Sony kristanto [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 14, 2003 8:49 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Date data type
>
>
> Hi Listers,
> Does the date data type is not consistence on oracleDB ?
> I have the query below :
>
> Create table test (dt date,
> name varchar230));
>
> SQL > Select * from test where dt between '01-DEC-02' and '31-DEC-02'
> - it returns 22 rows selected
>
> SQL > Select * from test where to_char(dt,'mmrr')='1202'
> - it returns 26 rows selected
>
> Why the last query return more rows selected than first query
> ? All comment would be appreciated.
>
> TIA,
>
> Sony
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Sony kristanto
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> and in the message BODY, include a line containing: UNSUB
> ORACLE-L (or the name of mailing list you want to be removed
> from). You may also send the HELP command for other
> information (like subscribing).
>
