Formatting TimeStamp

From: Alex <alex(at)meerkatsoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Formatting TimeStamp
Date: 2005-09-08 16:08:14
Message-ID: 432061EE.6000203@meerkatsoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2005-09-08 16:12:31 Re: Postgresql Hosting
Previous Message Alvaro Herrera 2005-09-08 15:53:16 Re: EMS PostgreSQL Manager vs. TheKompany DataArchitect