How to convert int year to date and display it as century SQL Oracle?

how can I convert int like ‘1984’ to date and display it as century SQL Oracle?

Answer

If the column is a date/time or timestamp:

select to_char(columnname, 'CC') as century from tablename;