From: Michael Fuhr <mike@fuhr.org>
To: Jerome Alet <alet@librelogiciel.com>
Cc: Christoph Haller <ch@rodos.fzk.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: string to date conversion
Date: Fri, 22 Apr 2005 04:22:26 -0600
Message-ID: <20050422102226.GA49805@winnie.fuhr.org> (raw)
In-Reply-To: <20050422093002.GI12176@mail.librelogiciel.com>
References: <20050422084301.GB12176@mail.librelogiciel.com>
<4268C216.8BC93C10@rodos.fzk.de>
<20050422093002.GI12176@mail.librelogiciel.com>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@fuhr.org, alet@librelogiciel.com, ch@rodos.fzk.de
Subject: Re: string to date conversion
In-Reply-To: <20050422102226.GA49805@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox