Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id BECF24769CE for ; Fri, 18 Oct 2002 14:23:36 -0400 (EDT) Received: from beamish.nsd.ca (unknown [205.150.156.194]) by postgresql.org (Postfix) with ESMTP id EB9C3476985 for ; Fri, 18 Oct 2002 14:23:35 -0400 (EDT) Received: (from smap@localhost) by beamish.nsd.ca (8.9.3/8.9.3) id OAA20666; Fri, 18 Oct 2002 14:23:34 -0400 X-Authentication-Warning: beamish.nsd.ca: smap set sender to using -f Received: from reddog.nsd.ca(192.168.101.30) by beamish.nsd.ca via smap (V2.1/2.1+anti-relay+anti-spam) id xma020664; Fri, 18 Oct 02 14:23:16 -0400 Received: from nsd.ca (jllachan-linux.nsd.ca [192.168.101.148]) by reddog.nsd.ca (8.8.7/8.8.7) with ESMTP id OAA28264; Fri, 18 Oct 2002 14:22:47 -0400 Message-ID: <3DB051C7.B4CBD73E@nsd.ca> Date: Fri, 18 Oct 2002 14:24:07 -0400 From: Jean-Luc Lachance X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.9-31 i686) X-Accept-Language: en MIME-Version: 1.0 To: wishy wishy Cc: pgsql-sql@postgresql.org Subject: Re: date References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/242 X-Sequence-Number: 9959 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@postgresql.org