From: | "Philippe Rochat (RSR: 318 17 93)" <prochat(at)lbdsun(dot)epfl(dot)ch> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
Cc: | postgres(at)lbdsun(dot)epfl(dot)ch |
Subject: | Time format ? (Really microsecond ??) |
Date: | 1998-10-22 10:37:35 |
Message-ID: | 362F0AEF.839F5A17@lbdsun.epfl.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
Hello, I'm trying to use microseconds in a field time:
siranau=> create table toto ( a time );
CREATE
siranau=> insert into toto values ('00:10:45.56');
INSERT 61641 1
siranau=> select * from toto;
a
--------
00:10:45
(1 row)
As you can see, I cannot get the microseconds value.
Something more problematic is the following:
% pg_dump -t toto siranau
\connect - siranau
CREATE TABLE toto (a time);
COPY toto FROM stdin;
00:10:45
\.
As you can see, microseconds values are lost !
Ph.R.
--
_____________________________________________________________________
Philippe Rochat, EPFL DI-LBD
Database Laboratory CH-1015 LAUSANNE
Swiss Federal Institute of Technology (EPFL) tel:++41 21 693 52 53
Beep-EPFL: 181 4644 fax:++41 21 693 51 95
Private: Grammont, 9 1007 LAUSANNE tel:++41 21 617 03 05
mailto:Philippe(dot)Rochat(at)epfl(dot)ch, http://lbdwww.epfl.ch/~prochat
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1998-10-22 12:05:39 | Re: [HACKERS] CVS Branch Tagging... |
Previous Message | Jan Wieck | 1998-10-22 10:30:38 | Re: [HACKERS] psql \d command |
From | Date | Subject | |
---|---|---|---|
Next Message | ronggui | 1998-10-22 13:05:47 | Help me ,Thank you !! |
Previous Message | Jan Wieck | 1998-10-22 10:04:50 | Re: [SQL] `statistical' aggregate functions etc. |