Postgresql - convert DATE into a specific DATE format

Question

I'm trying to convert the dates in my date column from:

yyyy-mm-dd

to

Month dd, yyyy

So far i've tried the below:

SELECT To_char(sq2.date_column, Month DD, YYYY)

but get the below error, despite my pattern aligning to the documentation

ERROR: syntax error at or near "DD"

I noticed in the documentation that To_char isn't explicitly referenced for date conversion (only time). Also, i'm not necessarily trying to alter the DATE type to VARCHAR. I would be happy to keep the data in the date_column as DATE type and just change the pattern.

Jim Jones · Accepted Answer · 2018-03-14 10:18:39Z

1

You were damn close. Just missed the ' at the second parameter.

SELECT To_char('2018-01-20'::date, 'Month DD, YYYY')

Using your table column:

SELECT To_char(sq2.date_column, 'Month DD, YYYY')

edited Mar 14, 2018 at 10:18

answered Mar 14, 2018 at 10:12

Jim Jones

19.9k3 gold badges44 silver badges51 bronze badges

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

Comments

Anand Singh · Accepted Answer · 2018-03-14 10:21:48Z

0

you have to use single code before month and end of the YYYY. you can use fallowing query for your required result
SELECT To_char(sq2.date_column, 'Month DD, YYYY')

answered Mar 14, 2018 at 10:21

Anand Singh

2102 silver badges13 bronze badges

Collectives™ on Stack Overflow

Postgresql - convert DATE into a specific DATE format

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related