Re: Help needed defining timestamp format for input?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: b(dot)wood(at)niwa(dot)co(dot)nz
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Help needed defining timestamp format for input?
Date: 2006-08-25 13:37:25
Message-ID: 23090.1156513045@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Brent Wood <b(dot)wood(at)niwa(dot)co(dot)nz> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-08-25 13:51:36 Re: ruby driver postgresql
Previous Message Ed Brown 2006-08-25 13:25:34 Content of pg_class.relacl