Re: y2k column datatype problem

Yes of course.
All components you don't specify are derived from the sysdate. You are searching for 01-jan-2097 implicitly. You either need to use RR instead of YY, or YYYY

Hth,

--
Sybrand Bakker, Oracle DBA

<rpereira_at_my-deja.com> wrote in message news:854h6o$g2k$1_at_nnrp1.deja.com...
> Hi gurus,
>
> Does anyboby knows why the query
> "select * from table_name where date_column > '01-jan-97'"
> returns "no rows selected"
> and the query
> "select * from table_name where date_column >
> to_date('01/01/1997','dd/mm/yyyy')"
> returns several lines ?
>
> No alter session was issued.
> In the props$ view the parameters are:
> NLS_LANGUAGE AMERICAN
> NLS_TERRITORY AMERICA
> NLS_CURRENCY $
> NLS_ISO_CURRENCY AMERICA
> NLS_NUMERIC_CHARACTERS .,
> NLS_DATE_FORMAT DD-MON-YY
> NLS_DATE_LANGUAGE AMERICAN
> NLS_CHARACTERSET WE8ISO8859P1
> NLS_SORT BINARY
> NLS_CALENDAR GREGORIAN
> NLS_RDBMS_VERSION 7.2.3.0.0
> In the v$parameter view the parameters are:
> nls_language AMERICAN
> nls_territory AMERICA
> nls_sort
> nls_date_language
> nls_date_format 'DD-MON-YY'
> nls_currency
> nls_numeric_characters
> nls_iso_currency
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Jan 07 2000 - 05:32:36 CST