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@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 Wed Dec 13 2000 - 18:53:59 CST

This message: [ Message body ]
Next message: Jay Weiland: "Re: How do I change the format of a date?"
Previous message: tirthankara: "How do I change the format of a date?"
In reply to: tirthankara: "How do I change the format of a date?"
Next in thread: Jay Weiland: "Re: How do I change the format of a date?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US