Postgres Pro
Downloads
Home   >   mailing lists

Timestamp output - Mailing list pgsql-general

From Matteo Beccati
Subject Timestamp output
Date
Msg-id 2780D698C269CB4EB303715BA48B6A104D32@sole.CRP
Whole thread Raw
Responses Transform and pivot  (Sonia Sanchez Diaz <sonny@piaget.dgsca.unam.mx>)
Re: Timestamp output  ("Robert Treat" <robertt@auctionsolutions.com>)
List pgsql-general
Tree view 
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/

pgsql-general by date:

Previous
From: replogle992@hotmail.com (Andrew Replogle)
Date:
Subject: pg_dump gives segmentation fault and cores
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: [SQL] transaction abortion