Re: y2k column datatype problem

rpereira_at_my-deja.com skrev i artiklen <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 ?

Try to do
insert into table_name(date_column) values('01-jan-97') and i think you will find that it has inserted 01-jan-2097 so your first query selects all dates > 01-jan-2097!

Peter Received on Fri Jan 07 2000 - 05:34:48 CST