Get month name from date in Oracle

Question

How to fetch month name from a given date in Oracle   If the given date is  15-11-2010  then I want November from this date

User · Answer

Try this   select to char SYSDATE  Month   from dual    for full name and try this  select to char SYSDATE  Mon   from dual    for abbreviation  you can find more option here   https   www techonthenet com oracle functions to char php

User · Answer

If you are trying to pull the value from a field  you could use   select extract month from  field name   from  table name    You can also insert day or year for the  month  extraction value above

User · Answer

select to char sysdate   Month   from dual   in your example will be   select to char to date  15-11-2010    DD-MM-YYYY     Month   from dual

User · Answer

to char mydate   MONTH   will do the job

User · Answer

In Oracle  atleast 11g  database    If you hit  select to char SYSDATE  Month   from dual    It gives unformatted month name  with spaces  for e g  May would be given as  May        The string May will have spaces   In order to format month name  i e to trim spaces  you need  select to char SYSDATE  fmMonth   from dual    This would return  May

User · Answer

Try this   select to char sysdate  dd   from dual  - gt  08  date  select to char sysdate  mm   from dual  - gt  02  month in number  select to char sysdate  yyyy   from dual  - gt  2013  Full year

[sql] Get month name from date in Oracle

Examples related to sql

Examples related to oracle

Examples related to date