X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (developer.postgresql.org [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP id 1B180B4389B
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  9 Jul 2003 08:29:53 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new,
	port 10024) with ESMTP id 93912-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  9 Jul 2003 05:29:41 -0300 (ADT)
Received: from anchor-post-33.mail.demon.net (anchor-post-33.mail.demon.net
	[194.217.242.91])
	by svr1.postgresql.org (Postfix) with ESMTP id AB05AB4388D
	for <pgsql-sql@postgresql.org>; Wed,  9 Jul 2003 05:29:41 -0300 (ADT)
Received: from mwynhau.demon.co.uk ([193.237.186.96]
 helo=mainbox.archonet.com)
	by anchor-post-33.mail.demon.net with esmtp (Exim 3.35 #1)
	id 19aAKb-000F0s-0X; Wed, 09 Jul 2003 09:29:42 +0100
Received: from localhost (localhost.localdomain [127.0.0.1])
	by mainbox.archonet.com (Postfix) with ESMTP
	id C767716DEF; Wed,  9 Jul 2003 09:29:40 +0100 (BST)
Received: from client.archonet.com (client.archonet.com [192.168.1.16])
	by mainbox.archonet.com (Postfix) with ESMTP
	id 0237016DEE; Wed,  9 Jul 2003 09:29:39 +0100 (BST)
Content-Type: text/plain;
  charset="iso-8859-1"
From: Richard Huxton <dev@archonet.com>
Organization: Archonet Ltd
To: Yasir Malik <ymalik@cs.stevens-tech.edu>,
	David Olbersen <DOlbersen@stbernard.com>
Subject: Re: Datatype conversion help
Date: Wed, 9 Jul 2003 09:29:44 +0100
User-Agent: KMail/1.4.3
Cc: pgsql-sql@postgresql.org
References: <E7E213858379814A9AE48CA6754F5ECB0D6F76@mail01.stbernard.com>
	<Pine.SGI.4.51.0307081715130.4138513@guinness.cs.stevens-tech.edu>
In-Reply-To: 
 <Pine.SGI.4.51.0307081715130.4138513@guinness.cs.stevens-tech.edu>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200307090929.44336.dev@archonet.com>
X-Virus-Scanned: by AMaViS snapshot-20020531
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200307/98
X-Sequence-Number: 14212

On Tuesday 08 Jul 2003 10:19 pm, Yasir Malik wrote:
> Yes, Mr. Nachbaur helped me out.  Thanks.  I don't think I can do
> to_char(<whatever date>, 'MM-DD-YYYY)
> because the date fields are originally stored as separate integers in my
> schema (they have to be that way).  I still can't understand why the extra
> space was added after the dash.  It just made my life more miserable.
> Yasir

You are not the only one it makes miserable. I believe it's there to provid=
e=20
compatibility with Oracle/some other db. Their function does it so ours=20
should too. Very strange behaviour though.

--=20
  Richard Huxton