For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
We have a table in Oracle with a date type column proto_date. When I run the following query :- Select EXTRACT(YEAR from proto_date) from tablename; I get result as -3832. Can Oracle store such date values where year is negative?
Select EXTRACT(YEAR from proto_date) from tablename;