Re: Changing default date format

From: Graham C Thornton <graham.thornton_at_ln.ssw.abbott.com>
Date: Mon, 19 Apr 1999 12:14:59 -0500
Message-ID: <7ffobf$ao6@news.abbott.com>

SQL> alter session set nls_date_format = 'DD-MM-YYYY';

Graham

Paul Wiles wrote in message <370e6771.0_at_newsread3.dircon.co.uk>...
>What do I need to do to change the default Oracle date format from DD-MM-YY
>to DD-MM-YYYY?
>
>I'm running Oracle 8 Server on Linux
>
>Thanks
>
>Paul
>
>
Received on Mon Apr 19 1999 - 12:14:59 CDT

This message: [ Message body ]
Next message: Dave Thompson: "Oracle 8i 8.1.5.0.0 server size in RAM"
Previous message: Chris Hamilton: "Re: saving username and sysdate on insert/update"
In reply to: Paul Wiles: "Changing default date format"

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