Re: How do I change the format of a date?
From: Jay Weiland <jay_at_pixar.com>
Date: Wed, 13 Dec 2000 16:33:12 -0800
Message-ID: <3A381548.7C84EF13_at_pixar.com>
Date: Wed, 13 Dec 2000 16:33:12 -0800
Message-ID: <3A381548.7C84EF13_at_pixar.com>
or if you really do not want the leading zeros
Jay!!!
tirthankara wrote:
> Hello,
select to_char(to_number(to_char(sysdate, 'mm'))) || '/' ||
to_char(to_number(to_char(sysdate, 'dd'))) || '/' ||
to_char(sysdate, 'yy')
from dual;
>
> How can I change the format of a DATE from 03-JUN-99 to 6/3/1999?
>
> Please help. Thanks.
>
> Sent via Deja.com
> http://www.deja.com/
--
Received on Thu Dec 14 2000 - 01:33:12 CET