Re: Timestamp output

Sigh - so many people not reading release notes... But then again, I
don't think this particular change was adequately documented in the
'observe the following incompatibilities' section of the HISTORY file -
maybe it should be in
7.2.1?

Although I know of this problem, I would also be interested in the fix.
I know that you can declare a column of type timestamp(0) to get the old
format, but how do you change an existing column? Add casts everywhere??

Chris

On Tue, 26 Feb 2002, Matteo Beccati wrote:

> Hi,
>
> I've just upgraded to 7.2, and found a big difference in timestamp
> output. I'm using the default ISO datestyle, and newly inserted
> timestamp output looks like that:
>
> 2002-02-25 16:50:49.289828+01
>
> What is the ".289828" which is breaking all my php scripts?
>
> Can I easily revert to the previous format?
>
> Thank you
> --
> Matteo Beccati
> C.R.P. Software S.r.l.
> http://www.crpsoftware.it/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>