Postgres Pro
Downloads
Home   >   mailing lists

Help needed defining timestamp format for input? - Mailing list pgsql-general

From Brent Wood
Subject Help needed defining timestamp format for input?
Date
Msg-id 44ED0F2D.8040607@niwa.co.nz
Whole thread Raw
In response to could not open relation - why?  ("Harald Armin Massa" <haraldarminmassa@gmail.com>)
Responses Re: Help needed defining timestamp format for input?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Achilleas Mantzios
Date:
Subject: CMS - portal server Question
Next
From: "JamieD"
Date:
Subject: PG8 Stalling/Not Exit/Not Performing Issue