http://qs321.pair.com?node_id=11127466


in reply to What defines the output format of a Postgres Timestamp

Now I'm wondering where the output format is defined.

A quick look at the documentation: sections 8.5.2. Date/Time Output and 19.11.2. Locale and Formatting appear to discuss this.

I would have to change each and every select statement to have a TO_CHAR with the proper format.

This StackOverflow answer suggests defining a function to curry the arguments.

In another piece of code I have lying around that uses Mojo::Pg, I use DateTime::Format::Strptime to parse the date strings coming from Postgres and DateTime's strftime to format them, though I suspect that's going to be less efficient than letting the database handle it.