From: Yasir Malik <ymalik@cs.stevens-tech.edu>
To: pgsql-sql@postgresql.org
Subject: Re: Datatype conversion help
Date: Tue, 8 Jul 2003 16:28:48 -0400
Message-ID: <Pine.SGI.4.51.0307081625220.4193960@guinness.cs.stevens-tech.edu> (raw)
In-Reply-To: <1057695693.24179.0.camel@localhost>
References: <Pine.SGI.4.51.0307081604030.4185018@guinness.cs.stevens-tech.edu>
<1057695693.24179.0.camel@localhost>
Thank you so much! But my problem is that when I do
to_char(mn, '00') || '-' || to_char(dy, '00') || '-' || to_char(yr,
'9999')
where mn, dy, and yr are ints, is that the output has a space after the
the dash. For example, I get
07- 25- 1994
instead of what I want:
07-25-1994
Thanks,
Yasir
On Tue, 8 Jul 2003, Richard Rowell wrote:
> Date: 08 Jul 2003 15:21:33 -0500
> From: Richard Rowell <richard@bowmansystems.com>
> To: Yasir Malik <ymalik@cs.stevens-tech.edu>
> Subject: Re: [SQL] Datatype conversion help
>
> On Tue, 2003-07-08 at 15:07, Yasir Malik wrote:
> > I've tried to_char(in_val, '99'), and that returns a string that is two
>
> select to_char(9,'00');
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ymalik@cs.stevens-tech.edu
Subject: Re: Datatype conversion help
In-Reply-To: <Pine.SGI.4.51.0307081625220.4193960@guinness.cs.stevens-tech.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox