Jerome Alet wrote:
>
> Hi,
>
> I'm working on an existing Pg database which, please don't ask why,
> stores dates as varchar attributes in the form 'YYYY/MM/DD'
>
> I'm not allowed to modify the tables to use 'timestamp' instead,
> so I'd like to convert on the fly when retrieving datas with
> select.
>
> When I do :
>
> select mydatefield::timestamp from mytable;
>
> There's an error saying that converting from varchar to date is
> not possible
>
> How can I do this ?
>
> Thanks in advance
>
> Jerome Alet
>
select version();
version
-------------------------------------------------------------------------------------
PostgreSQL 7.4.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.1
(SuSE Linux)
(1 row)
select '2005/04/22'::text::timestamp ;
timestamp
---------------------
2005-04-22 00:00:00
(1 row)
works for me.
Regards, Christoph
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
