Postgres quarter function

Question

When running

select to_char ("dateoftransfer", '"Q"quarter YYYY') as quarterly
FROM table;

I get back Q3uarter 2001 but expect Q3 2001

"dateoftransfer" is data type date

What am i doing wrong?

Gordon Linoff · Accepted Answer · 2017-04-16 17:54:04Z

3

I think you are looking for this format:

select to_char(dateoftransfer, '"Q"Q YYYY')

answered Apr 16, 2017 at 17:54

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

3 Comments

Thank you! I had no idea you could do that

I'm trying to use this in conjunction withINSERT INTO but this doesn't work, is the syntax wrong?

@mappingdom . . . You should ask another question.