Q:

Extract Month From Date Field

I have a date field in a postgresql database (field name is input) how can I extract the month only from the date field?  I used the syntax below, but I want it to show the actual month name, not a numeric value for the month
EXTRACT(MONTH FROM input) AS "Month"

So if the date in the field input was 04/26/2016 this syntax returns 4, how could I alter this to return April

A:

A simpler version.
to_char(input, 'Month') AS Month 
Source : Data Type Formatting Functions

A:

You may find this useful
SELECT to_char(to_timestamp (date_part('month', timestamp '2016-04-26 20:38:40')::text, 'MM'), 'Month')
All the best
Ref Postgresql (Current) Section 9.9. Date/Time Functions and Operators

