Обсуждение: How to show timestamp with milliseconds(3 digits) in Select clause in Ver7.1 ?
This is the query and result: select h323_setup_time from pv_legs_new where h323_setup_time = '2003-01-01 00:43:59.996-05'; h323_setup_time ---------------------------2003-01-01 00:43:60.00-05 Actually, the real data of second and millisecond is 59.996-05, but it shows 60.00. I failed to load it when I use this result in other query.
"Liang Luo" <liang.luo@convergia.net> writes: > 2003-01-01 00:43:60.00-05 > Actually, the real data of second and millisecond is 59.996-05, but it shows > 60.00. I failed to load it when I use this result in other query. This looks like an old bug. What Postgres version are you using, and on what platform? regards, tom lane
Re: How to show timestamp with milliseconds(3 digits) in Select clause in Ver7.1 ?
От
"Liang Luo"
Дата:
My version is 7.1, and I also have another version 7.2 but this problem does not happen on version 7.2. Now I want to dump these data out from version 7.1 and upgrade it, and then load these data into version 7.2 Thanks, Liang -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Wednesday, March 26, 2003 9:07 AM To: liang.luo@convergia.net Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] How to show timestamp with milliseconds(3 digits) in Select clause in Ver7.1 ? "Liang Luo" <liang.luo@convergia.net> writes: > 2003-01-01 00:43:60.00-05 > Actually, the real data of second and millisecond is 59.996-05, but it shows > 60.00. I failed to load it when I use this result in other query. This looks like an old bug. What Postgres version are you using, and on what platform? regards, tom lane