From: | "Carel Combrink" <s25291930(at)tuks(dot)co(dot)za> |
---|---|
To: | "PostgreSQL Novice List" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Timestamp with Precision |
Date: | 2010-08-24 09:45:12 |
Message-ID: | 20100824114512.451473546kikldpk@student.up.ac.za |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
I have a table defined as :
CREATE TABLE time_test(tt timestamp(4) with time zone);
I want to return the values inside the table but with the trailing
zeros displayed. Is there a easy solution for this or do I need to
create a function that can do this?
When I do:
INSERT INTO time_test(tt) VALUES ('2010-08-24 11:32:23.010');
and then:
SELECT * FROM time_test;
tt
-----------------------------
2010-08-24 11:32:23.01+02
(3 rows)
I would like to get a value like
SELECT * FROM time_test;
tt
-----------------------------
2010-08-24 11:32:23.0100+02
(3 rows)
Thank you,
--
Carel Combrink
s25291930(at)tuks(dot)co(dot)za
This message and attachments are subject to a disclaimer. Please refer
to www.it.up.ac.za/documentation/governance/disclaimer/ for full
details. / Hierdie boodskap en aanhangsels is aan 'n vrywaringsklousule
onderhewig. Volledige besonderhede is by
www.it.up.ac.za/documentation/governance/disclaimer/ beskikbaar.
From | Date | Subject | |
---|---|---|---|
Next Message | solaimurugan v | 2010-08-24 11:32:28 | RESTORE DATABASE BACKUP TO MODIFIED DATABASE |
Previous Message | George H | 2010-08-24 08:04:48 | Re: How to install UUID module postgres 8.4.4 [Solved] |