Reputation: 351
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...
Upvotes: 4
Views: 8755
Reputation: 1271241
Use to_char()
:
to_char(to_date(proforma_invoice_date, 'DD/MM/YYYY'), 'Month')
Upvotes: 11