Postgresql to_char() function for all results from a query

Question

So I have been doing some work with postgreSQL and dealing with formatting the dates that I receive as an output from a simple query.

To run my query and return my list of dates I simply call something like:

select date from tablename;

This works well, and returns back to me a large list of dates in a format that is slightly off from my desired output.

Then after doing some research I discovered the function TO_CHAR(). This I had some success with again - I was able to call the function like so: select to_char(NOW(), 'Month dd, YYYY');

My question and where I have gotten stuck with some errors is how I might be able to pass in the results from the initial query into the to_char() function.

Apologies if this is a relatively basic question (I am a beginner when it comes to postgresql).

For client privacy reasons I would prefer not to. Hope you understand and that my intention with the question is clear. — Sean_Boothby
– Sean_Boothby, Commented Oct 1, 2018 at 20:48

Joe Love · Accepted Answer · 2018-10-01 21:03:23Z

1

As simple as the following:

select to_char(tablename.date, 'Month dd, YYYY') from tablename;

answered Oct 1, 2018 at 21:03

Joe Love

6,1262 gold badges24 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

Postgresql to_char() function for all results from a query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related