How to show timestamp with milliseconds(3 digits) in Select clause in Ver7.1 ? - Mailing list pgsql-sql

From Liang Luo
Subject How to show timestamp with milliseconds(3 digits) in Select clause in Ver7.1 ?
Date
Msg-id 00e401c2f2dc$3aa87280$e6071cac@convergia.com
Whole thread Raw
Responses Re: How to show timestamp with milliseconds(3 digits) in Select clause in Ver7.1 ?
List pgsql-sql
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.



pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Does anyone use TO_CHAR(INTERVAL)?
Next
From: Roy Souther
Date:
Subject: Insert race hazard condition.