Postgres Pro
Downloads
Home   >   mailing lists

Re: string to date conversion - Mailing list pgsql-sql

From Jerome Alet
Subject Re: string to date conversion
Date
Msg-id 20050422093002.GI12176@mail.librelogiciel.com
Whole thread Raw
In response to Re: string to date conversion  (Christoph Haller <ch@rodos.fzk.de>)
Responses Re: string to date conversion  (Michael Fuhr <mike@fuhr.org>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Christoph Haller
Date:
Subject: Re: string to date conversion
Next
From: Andreas Kretschmer
Date:
Subject: Re: [despammed] How do I connect with something like JDBCManager to Postgres on Fedora Linux