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: OF5C75E496.E6AA175A-ON85256EBA.006FBE42-85256EBA.00701CDD@apcc.com (view raw or flat)
Thread:
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 hh:mm:ss.ms.  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?

--Chris



Responses

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-2014 The PostgreSQL Global Development Group