y2k column datatype problem

From: <rpereira_at_my-deja.com>
Date: Fri, 07 Jan 2000 11:03:57 GMT
Message-ID: <854h6o$g2k$1@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:03:57 CST