CODEWITHSUNDEEP
postgresql-9.4postgresql-9.6
mapping dom
mapping dom

Reputation: 1955

Postgres quarter function

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?

Upvotes: 2

Views: 2031

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1270493

I think you are looking for this format:

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

Upvotes: 3

Related Questions