Answer the question
In order to leave comments, you need to log in
Postgres month and year selection?
Is there a more beautiful output of the year and month than this?
select EXTRACT(year FROM TIMESTAMP '2001-02-16') ||'-'|| EXTRACT(MONTH FROM TIMESTAMP '2001-02-16') ;
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question