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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: liang(dot)luo(at)convergia(dot)net
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to show timestamp with milliseconds(3 digits) in Select clause in Ver7.1 ?
Date: 2003-03-26 14:06:51
Message-ID: 4633.1048687611@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Liang Luo" <liang(dot)luo(at)convergia(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Greg Stark 2003-03-26 14:36:11 Re: Complex outer joins?
Previous Message Stefan Berg 2003-03-26 12:18:13 Database not restarting