From: | Jean-Luc Lachance <jllachan(at)nsd(dot)ca> |
---|---|
To: | wishy wishy <wishy66(at)hotmail(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: date |
Date: | 2002-10-18 18:24:07 |
Message-ID: | 3DB051C7.B4CBD73E@nsd.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Try
select to_char( '1969-10-22'::date, 'YYYY-MM-DD');
wishy wishy wrote:
>
> hi folks,
> we have a PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC 2.96
> installation on pogo linux 7.2
> we are facing a data problem when we do the following
> select to_char(to_date('1969-10-22','YYYY-MM-DD'),'YYYY-MM-DD');
>
> ERROR: Unable to convert date to tm
>
> we have been trying to find a solution for this have you found such
> instances before it there a method to over come this.
> Any help will be greatly appreciated.
> thanks
> kris
>
> _________________________________________________________________
> Get faster connections -- switch to MSN Internet Access!
> http://resourcecenter.msn.com/access/plans/default.asp
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Luc Lachance | 2002-10-18 18:24:55 | Re: [SQL] isAutoIncrement and Postgres |
Previous Message | Stephan Szabo | 2002-10-18 18:18:22 | Re: [SQL] foreign key, create table, and transactions |