"Costin Manda" <siderite(at)madnet(dot)ro> writes:
> select setuptime::timestamp from billing; - error (cannot cast type
> character varying to timestamp without timezone!?)
It works for me in 8.0. In some releases you need to cast to text
first, for example in 7.4:
regression=# select '2005-10-10 10:10:10'::varchar::timestamp;
ERROR: cannot cast type character varying to timestamp without time zone
regression=# select '2005-10-10 10:10:10'::varchar::text::timestamp;
timestamp
---------------------
2005-10-10 10:10:10
(1 row)
regards, tom lane