Get month name from date in Oracle

by 
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

More Related Contents:

  1. Current date in Oracle Db
  2. Oracle’s default DATE format
  3. Check if current date is between two dates Oracle SQL
  4. Comparing with date in Oracle sql
  5. Return number from Oracle Select statement after parsing date
  6. Subtracting Dates in Oracle – Number or Interval Datatype?
  7. Oracle Convert TIMESTAMP with Timezone to DATE
  8. Receive an unexpected symbol error in my PLSQL query [closed]
  9. Select First Row of Every Group in sql [duplicate]
  10. Oracle: how to UPSERT (update or insert into a table?)
  11. Comparing Dates in Oracle SQL
  12. Oracle SQL query: Retrieve latest values per group based on time [duplicate]
  13. SQL – How to store and navigate hierarchies?
  14. GROUP BY / aggregate function confusion in SQL
  15. Oracle “(+)” Operator
  16. How do you create a temporary table in an Oracle database?
  17. What exactly do quotation marks around the table name do?
  18. How can I get column names from a table in Oracle?
  19. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  20. How to check the maximum number of allowed connections to an Oracle database?
  21. Select without a FROM clause in Oracle
  22. Oracle insert if row does not exist
  23. SELECT INTO using Oracle
  24. Display names of all constraints for a table in Oracle SQL
  25. Query json dictionary data in SQL
  26. ORA-00972 identifier is too long alias column name
  27. Postgresql query between date ranges
  28. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  29. Why doesn’t Oracle SQL allow us to use column aliases in GROUP BY clauses?
  30. Oracle ‘Partition By’ and ‘Row_Number’ keyword

Leave a Comment