Re: [SQL] How to show timestamp with milliseconds(3 digits) in Select clause in Ver7.1 ?

2003-03-26 Thread Tom Lane
"Liang Luo" <[EMAIL PROTECTED]> 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 plat

Re: [SQL] How to show timestamp with milliseconds(3 digits) in Select

2003-03-26 Thread Christoph Haller
> > 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