Date field query

admin

Administrator
Staff member
I have a table which has a column of datatype DATE.

Recently when i queried for the column i found it has 00/00/0000 inserted in it.

How is it possible to insert zero in a date field in Oracle. Will it not give an error.
 
Back
Top