Re: Custom datestyle for timestamps

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Custom datestyle for timestamps
Date: 2009-03-06 15:19:49
Message-ID: 28277.1236352789@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Daniel Verite" <daniel(at)manitou-mail(dot)org> writes:
> I think it would valuable to have at least a default format that
> doesn't include the sub-second precision, since it typically adds 7
> characters that enlarge output columns in a way that is generally
> useless to the human eyes. Do other users agree with that?

If you think it's useless, just store your timestamps in a timestamp(0)
column.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2009-03-06 15:49:05 Installing a module for PostgreSQL
Previous Message Aaron 2009-03-06 13:47:35 iSCSI SAN Suggestions