Re: string to date conversion

From: Jerome Alet <alet(at)librelogiciel(dot)com>
To: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: string to date conversion
Date: 2005-04-22 09:30:02
Message-ID: 20050422093002.GI12176@mail.librelogiciel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

bye

Jerome Alet

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Kretschmer 2005-04-22 09:35:13 Re: [despammed] How do I connect with something like JDBCManager to Postgres on Fedora Linux
Previous Message Adriaan Botha 2005-04-22 09:22:50 How do I connect with something like JDBCManager to Postgres on Fedora Linux