Negative year value in date type column in Oracle-CodePudding

Home > front end > Negative year value in date type column in Oracle

Negative year value in date type column in Oracle

Time：05-20

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?

CodePudding user response：

Can Oracle store such date values where year is negative?

Oracle dates can range in year from 4712 BC to 9999 AD. Extracting the year from a BC date will yield a negative number.