Re: nls_date

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Sat, 6 May 2006 16:14:57 +0200
Message-ID: <486b2b610605060714y66b47734p341055d1676cd43c@mail.gmail.com>

You could try using a user-defined data type that returns your date in the desired format

Stefan

On 5/6/06, raja rao <raja4list_at_yahoo.com> wrote:
>
> Hi All,
>
> My nls_date_format is dd-mm-rr
>
> i want one schema's tables date format should be in mm-dd-yy. (rest is
> fine with dd-mm-rr).
>
> is there a way todo this.
> (apart from using alter session set nls_date_format='mm-dd-yy');
>
>
> can someone help me ?
>
> Thanks,
> RAj
>
> ------------------------------
> Yahoo! Messenger with Voice.<http://us.rd.yahoo.com/mail_us/taglines/postman3/*http://us.rd.yahoo.com/evt=39666/*http://messenger.yahoo.com>PC-to-Phone calls for ridiculously low rates.
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sat May 06 2006 - 09:14:57 CDT