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@pixar.com>

If you are asking about date format in SQL*Plus

select TO_CHAR(sysdate, 'mm/dd/yyyy')
from dual;

or if you really do not want the leading zeros

select to_char(to_number(to_char(sysdate, 'mm'))) || '/' ||
       to_char(to_number(to_char(sysdate, 'dd'))) || '/' ||
       to_char(sysdate, 'yy')

from dual;

Jay!!!

tirthankara wrote:

> Hello,
>
> 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 Wed Dec 13 2000 - 18:33:12 CST