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



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

hi,

Christopher.Becker (AT) apcc (DOT) com wrote, On 6/21/2004 22:24:
try:
SELECT current_timestamp;

C.

Christopher.Becker (AT) apcc (DOT) com writes:
Well, you can't see precision that isn't there. How are you inserting
data?

The only way the column itself would be throwing away low-order digits
is if you declared it to, with a declaration like "timestamp(0)".
Example:

regression=# create table foo(f1 timestamptz);
CREATE TABLE
regression=# insert into foo values(now());
INSERT 155060 1
regression=# select * from foo;
f1
-------------------------------
2004-06-21 21:44:47.344823-04
(1 row)

regression=# create table bar (f1 timestamp(0) with time zone);
CREATE TABLE
regression=# insert into bar values(now());
INSERT 155063 1
regression=# select * from bar;
f1
------------------------
2004-06-21 21:46:36-04
(1 row)


regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org