date data type showing only year
can i do something like this???
alter table T
modify (year date format'yyyy');
OR
create table T (
year date format('yyyy'));
I want to store only year in a year column.
I know that i can use "column format" or to_date, or to_char but these only for selecting or inserting.
I want the year to be stored in a column without using these functions.
Thanks in advance.