How to convert number to month name in PostgreSQL?

Question

I m trying to convert string number to month name but i searched a lot of resources but it didn't help me.

here is my query

SELECT CAST(extract('month'
                    FROM to_date(proforma_invoice_date, 'DD/MM/YYYY')) AS VARCHAR) AS proforma_invoice_date
FROM proforma_invoice

Here is my output...

Unrelated to your problem, but: why are you storing DATE values in a varchar column? That is a really bad idea to begin with. — user330315
– user330315, Commented Dec 10, 2019 at 12:27

Tyler2P · Accepted Answer · 2024-06-24 20:10:32Z

11

Use to_char():

to_char(to_date(proforma_invoice_date, 'DD/MM/YYYY'), 'Month')

edited Jun 24, 2024 at 20:10

Tyler2P

2,37030 gold badges26 silver badges34 bronze badges

answered Dec 10, 2019 at 12:26

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to convert number to month name in PostgreSQL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related