[GENERAL] Help needed defining timestamp format for input?

Hi, I've been given a dataset (from Sybase) which has the timestamps expressed as Jun 26 2002 12:18:56:903PM I'd like to use copy in Postgres to load these data, but can't see in the (v8.1) docs how to specify this format for Postgresql. Can anyone help with this? Thanks, Brent Wood

Re: [GENERAL] Help needed defining timestamp format for input?

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.