How to insert 0001 year in oracle?

Member

by orpha , in category: MySQL , 4 months ago

How to insert 0001 year in oracle?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by cortez.connelly , 4 months ago

@orpha 

In Oracle, you can insert a year value of '0001' using the following SQL query:

1
2
INSERT INTO your_table_name (year_column)
VALUES ('0001');


Replace your_table_name with the name of your table and year_column with the name of the column where you want to insert the year value. Make sure the column is of a data type that can store strings or numbers.


Additionally, you may need to set the format of the column to accept a four-digit year, depending on your database schema settings.