On Tue, Apr 29, 2008 at 10:46 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Lonni J Friedman" <netllama@gmail.com> writes:
> > Unfortunately, I can't just do:
> > ALTER TABLE data ALTER COLUMN date_created TYPE timestamp ;
>
> > since the data is currently in this format:
> > 04-29-2008 10:03:28
>
> I think you're just missing an explicit cast:
>
> ALTER TABLE data ALTER COLUMN date_created TYPE timestamp USING date_created::timestamp;
>
> You should first check that datestyle is set to MDY to avoid
> any confusion about the field order, but other than that I don't
> see why you'd have a format problem.

Excellent, that worked perfectly. thanks!


--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~
L. Friedman netllama@gmail.com
LlamaLand https://netllama.linux-sxs.org

--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice