Skip site navigation (1) Skip section navigation (2)

formatting timestamptz for more precision?

From: Christopher(dot)Becker(at)apcc(dot)com
To: pgsql-novice(at)postgresql(dot)org
Subject: formatting timestamptz for more precision?
Date: 2004-06-21 20:24:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

From what I've read, Postgres stores plenty of precision to contain
milliseconds.  My question is, how do I see the milliseconds?  Just doing a
select on a timestamptz column just gives me hh:mm:ss... but i'm looking
for something more like  Is there someway to do a format
within the select so that I can see the miliseconds as well as the rest of
the time?



pgsql-novice by date

Next:From: Tom LaneDate: 2004-06-22 01:48:34
Subject: Re: formatting timestamptz for more precision?
Previous:From: JánosDate: 2004-06-21 13:43:32
Subject: Re: benefits of an Array Column?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group