Brent Wood <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to