Help needed defining timestamp format for input?

From: Brent Wood <b(dot)wood(at)niwa(dot)co(dot)nz>
To:
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Help needed defining timestamp format for input?
Date: 2006-08-24 02:30:05
Message-ID: 44ED0F2D.8040607@niwa.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2006-08-24 02:34:43 Re: Inserting Data
Previous Message Bruce Momjian 2006-08-24 01:41:07 Re: [GENERAL] pgxml & xpath_table