Re: Custom datestyle for timestamps - Mailing list pgsql-general

From Tom Lane
Subject Re: Custom datestyle for timestamps
Date
Msg-id 28277.1236352789@sss.pgh.pa.us
Whole thread Raw
In response to Re: Custom datestyle for timestamps  ("Daniel Verite" <daniel@manitou-mail.org>)
List pgsql-general
"Daniel Verite" <daniel@manitou-mail.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

pgsql-general by date:

Previous
From: Aaron
Date:
Subject: iSCSI SAN Suggestions
Next
From: Thom Brown
Date:
Subject: Installing a module for PostgreSQL