Postgres Pro
Downloads
Home   >   mailing lists

Timestamp output - Mailing list pgsql-sql

From Matteo Beccati
Subject Timestamp output
Date
Msg-id 2780D698C269CB4EB303715BA48B6A103368@sole.CRP
Whole thread Raw
Responses Re: Timestamp output  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-sql
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-sql by date:

Previous
From: Jerome Alet
Date:
Subject: Re: test the existence of a database
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Timestamp output