I am using Oracle7.1 database and I have one date datatype column in a table. When I use "where date_column = TO_DATE('01-JAN-01')" in my query, it just works fine. But if I use "where date_column = TO_DATE('01 01 0001', 'mm dd yyyy')", it returns no rows. TO_DATE('01/01/01', 'mm/dd/yy') format doesn't work either. Does anyone know what is the problem? Is something wrong with the data stored in the table? Thank in advance. Jerry Received on Fri Feb 23 1996 - 00:00:00 CET
Does anyone know what is the problem? Is something wrong with the data stored in the table?
Thank in advance.
Jerry
Original text of this message
