Re: Help needed defining timestamp format for input?

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