form30 to_date() function

Thanks in advance

i have following table

col1 number..
col2 Date
col3 Date
..

the problem that i am having is as follows:

i use oracle insert to table.col2
and i use forms to assign value to table.col3

now both columns have date format, but when i try to retreive or query data via sqlplus
i have to write my query as follow                                              

select * from table where to_date(col2) ='01-JAN-95'

                      and col3 = '01-JAN-95'

my question is why i need to use to_date on col2 to be able to query any data.

any help would greatly appriciated

Thanks Again ;^)

Katy Wang
KATY.WANG_at_ab.com   Received on Fri Apr 14 1995 - 00:00:00 CEST