recasting to timestamp from varchar - Mailing list pgsql-general

From Kirk Wythers
Subject recasting to timestamp from varchar
Date
Msg-id 6ADA513E-CF10-48B1-B454-35A31EA7600A@umn.edu
Whole thread Raw
Responses Re: recasting to timestamp from varchar  (Chris Angelico <rosuav@gmail.com>)
Re: recasting to timestamp from varchar  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
I am trying to re-cast a column as a timestamp>

ALTER TABLE sixty_min ALTER COLUMN time2 TYPE timestamp;
ERROR:  column "time2" cannot be cast to type timestamp without time zone

The column time2 is currently a varchar. I actually do not want to mess with time zones, but it seems that postgres will not let me do this. The actual values in the column time2 look like this:

7/15/08 12:00

Is this possible? 

pgsql-general by date:

Previous
From: Greg Donald
Date:
Subject: pgpool2 load balancing not working
Next
From: Kirk Wythers
Date:
Subject: recasting to timestamp from varchar