Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A28B7475D84 for ; Fri, 18 Oct 2002 06:24:49 -0400 (EDT) Received: from hotmail.com (f53.law9.hotmail.com [64.4.9.53]) by postgresql.org (Postfix) with ESMTP id 16799475D3B for ; Fri, 18 Oct 2002 06:24:49 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 18 Oct 2002 03:24:51 -0700 Received: from 203.195.201.67 by lw9fd.law9.hotmail.msn.com with HTTP; Fri, 18 Oct 2002 10:24:50 GMT X-Originating-IP: [203.195.201.67] From: "wishy wishy" To: pgsql-sql@postgresql.org Subject: Re: date Date: Fri, 18 Oct 2002 10:24:50 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 18 Oct 2002 10:24:51.0233 (UTC) FILETIME=[97B42910:01C27690] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/221 X-Sequence-Number: 9938 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