X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5CF4C474E44 for ; Wed, 5 Feb 2003 23:25:44 -0500 (EST) Received: from israel.diaspora.gen.nz (israel.diaspora.gen.nz [202.50.109.65]) by postgresql.org (Postfix) with ESMTP id AFB93474E42 for ; Wed, 5 Feb 2003 23:25:43 -0500 (EST) Received: from rodgerd by israel.diaspora.gen.nz with local (Exim 3.35 #1 (Debian)) id 18gdbX-0002Cp-00; Thu, 06 Feb 2003 17:25:39 +1300 Date: Thu, 6 Feb 2003 17:25:39 +1300 To: Tom Lane Cc: pgsql-sql@postgresql.org Subject: Re: to_date has beaten me... Message-ID: <20030206042539.GA8420@diaspora.gen.nz> Reply-To: rodgerd@diaspora.gen.nz References: <20030206040247.GA8032@diaspora.gen.nz> <9133.1044505377@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <9133.1044505377@sss.pgh.pa.us> User-Agent: Mutt/1.3.28i From: Rodger Donaldson X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/106 X-Sequence-Number: 11504 On Wed, Feb 05, 2003 at 11:22:57PM -0500, Tom Lane wrote: > Rodger Donaldson writes: > > values (to_date('06/Feb/2003:11:29:11 +13', 'DD/Mon/YYYY:HH24:MI:SS'),0,302, > > > Always inserts the correct date, but sets the time to midnight. > > Um, well, yeah ... it's to_DATE, meaning it produces a result of type > date. I think you wanted to_timestamp(). Why yes. Yes I did. Too much time spent with Oracle, evidently. Next I'll be wondering why DECODE doesn't work... -- Rodger Donaldson rodgerd@diaspora.gen.nz "How do I set my laser printer for stun?" -- William Tansil