| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Jerome Alet <alet(at)librelogiciel(dot)com> |
| Cc: | Christoph Haller <ch(at)rodos(dot)fzk(dot)de>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: string to date conversion |
| Date: | 2005-04-22 10:22:26 |
| Message-ID: | 20050422102226.GA49805@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2005-04-22 14:50:14 | Re: [SQL] How to install Postgres that supports 64-bit |
| Previous Message | KÖPFERL Robert | 2005-04-22 09:46:26 | Re: How do I connect with something like JDBCManager to Pos |