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