When i perform this query

SELECT CURRENT_DATE FROM DUAL;

I get current date with month in shortcut format (NOV). How can i get the same result but getting month in full format(NOVEMBER) and in numerical value

CodePudding user response：

I know there are built in formatting options in MSSQL, and assume there are in Oracle. A quick google gave me this website that shows how:

https://www.oracletutorial.com/oracle-basics/oracle-date/

SELECT
  TO_CHAR( SYSDATE, 'YYYY-MM-DD' )
FROM
  dual;