Brent Wood <b.wood@xxxxxxxxxx> 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
