How to display month in different formats

Question

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

See https://stackoverflow.com/questions/66263759/oracle-date-format-while-using-to-char — Sam M, Nov 04 '22 at 22:39
[The Oracle documentation](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/TO_CHAR-datetime.html) is a good place to start. I realise it helps if you know where to look in the docs, but there are [more general topics](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Single-Row-Functions.html#GUID-5652DBC2-41C7-4F07-BEDD-DAF620E35F3C) that can point you in the right direction. — Alex Poole, Nov 04 '22 at 23:34

Kevon · Accepted Answer · 2022-11-05T00:14:25.190

0

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;

edited Nov 05 '22 at 00:14

answered Nov 04 '22 at 21:37

Kevon

984
8
28

I still cant find how to display it like numeric value – Octopus Nov 04 '22 at 21:56
what is the specific format you want? 2022-12-31 – Kevon Nov 04 '22 at 23:02
yes. this format – Octopus Nov 05 '22 at 00:01
Edited answer with correct format – Kevon Nov 05 '22 at 00:14

How to display month in different formats

1 Answers1