As title, ORACLE there is a year () function?
Only through to_number (to_date ()) turn?

CodePudding user response:

Select the extract (year from sysdate) from dual

CodePudding user response:

The SELECT TO_NUMBER (TO_CHAR (SYSDATE, 'YYYY)) FROM DUAL