Postgres Pro
Downloads
Home   >   mailing lists

recasting to timestamp from varchar - Mailing list pgsql-general

From Kirk Wythers
Subject recasting to timestamp from varchar
Date
Msg-id F6271478-F35C-4A05-8173-00DBAFC7FD6C@gmail.com
Whole thread Raw
Responses Re: recasting to timestamp from varchar  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view
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: Ali Pouya
Date:
Subject: Re: Monitoring streaming replication from standby on Windows
Next
From: Pavel Stehule
Date:
Subject: Re: recasting to timestamp from varchar