DATE to MONTH NAME

How can I turn
April 9, 2019, 12:00 AM into MONTH NAME - APRIL

none of the format sql queries i tried worked.

Hi @Ninappp
You should ask general database query syntax questions in a forum specific to your database - or perhaps stackoverflow.com

I have done this earlier.

Can you please write a simple query to extract only the date column and share that query?
And please also share the output of that query. (Top 10 rows)

I used this one and it works. I needed it for a graph

SELECT
date_trunc(‘month’, CAST(.“order”.“client_sent_payment_at” AS timestamp)) AS “client_sent_payment_at”,
FROM “order”
group by date_trunc(‘month’, CAST(.“order”.“client_sent_payment_at” AS timestamp))

It combines them by month names in a graph but in a table it shows like this
marzo 1, 2020, 12:00 AM