Re: Datatype conversion help

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(at)bowmansystems(dot)com>
> To: Yasir Malik <ymalik(at)cs(dot)stevens-tech(dot)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');
>