Formatting TimeStamp - Mailing list pgsql-general

Hi,

I am using the timestamp various tables but dont like to see the
microseconds.
Is there way to format the output of timestamp fields globally (in the
postgres.conf)?
Preferably i only would like to see the YYYYMMDD HH:MM:SS.

Or can a formatting be passed to a SELECT * .... hmmm probably not.

Thanks for any advise

A