On Fri, Apr 22, 2005 at 11:30:02AM +0200, Jerome Alet wrote:
> On Fri, Apr 22, 2005 at 11:21:26AM +0200, Christoph Haller wrote:
> >
> > select '2005/04/22'::text::timestamp ;
> > timestamp
> > ---------------------
> > 2005-04-22 00:00:00
> > (1 row)
> >
> > works for me.
>
> It works fine !!!
>
> Thanks so much for your help.
>
> I missed the '::text' intermediate conversion it seems
This is fixed in 8.0 (in 8.0.2, anyway). Casts from varchar no
longer need an intermediate cast to text.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/