Postgres Pro
Downloads
Home   >   mailing lists

Re: Help needed defining timestamp format for input? - Mailing list pgsql-general

From Tom Lane
Subject Re: Help needed defining timestamp format for input?
Date
Msg-id 23090.1156513045@sss.pgh.pa.us
Whole thread Raw
In response to Help needed defining timestamp format for input?  (Brent Wood <b.wood@niwa.co.nz>)
List pgsql-general
Tree view 
Brent Wood <b.wood@niwa.co.nz> writes:
> I've been given a dataset (from Sybase) which has the timestamps
> expressed as
> "Jun 26 2002 12:18:56:903PM"

That's pretty bizarre.  My advice is to run a quick perl or sed script
over the data and change the (I assume) fractional seconds delimiter
to a dot.  PG will take timestamps like
  "Jun 26 2002 12:18:56.903PM"

            regards, tom lane

pgsql-general by date:

Previous
From: "Bartosz Belter"
Date:
Subject: 7.4 - data recovery
Next
From: Michael Fuhr
Date:
Subject: Re: ruby driver postgresql