How can I turn
April 9, 2019, 12:00 AM into MONTH NAME - APRIL
none of the format sql queries i tried worked.
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