Re: How do I change the format of a date?
From: Stefan Rudolph-Klindtwort <StefanRudolph-Klindtwort_at_t-online.de>
Date: Thu, 14 Dec 2000 01:53:59 +0100
Message-ID: <9195kd$1ru$05$1_at_news.t-online.com>
Date: Thu, 14 Dec 2000 01:53:59 +0100
Message-ID: <9195kd$1ru$05$1_at_news.t-online.com>
Hello,
try the following select ... , to_char( any_date_field, 'DD/MM/YYYY' ) from ...
Hope that helps...
"tirthankara" <tirthankara_at_my-deja.com> schrieb im Newsbeitrag
news:918u7k$eg2$1_at_nnrp1.deja.com...
> 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 Thu Dec 14 2000 - 01:53:59 CET