recasting to timestamp from varchar

Поиск
Список
Период
Сортировка
От Kirk Wythers
Тема recasting to timestamp from varchar
Дата
Msg-id F6271478-F35C-4A05-8173-00DBAFC7FD6C@gmail.com
обсуждение исходный текст
Ответы Re: recasting to timestamp from varchar  (Pavel Stehule <pavel.stehule@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Ali Pouya
Дата:
Сообщение: Re: Monitoring streaming replication from standby on Windows
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: recasting to timestamp from varchar