Re: sqlplus does not display time portion from a date column

From: dsmcd <dsmcd_at_stopspamdormouse.net>
Date: Thu, 30 Oct 2003 19:22:39 GMT
Message-ID: <3ydob.182$Bi3.48880@news.uswest.net>

Ken Denny <ken_at_kendenny.com> wrote:

>
>alter session set nls_date_format='MM/DD/YYYY HH24:MI:SS';
>
>You can put in in your login file so it happens
>automatically whenever you
>bring up sqlplus.
>

Very nice. Thank you!
D. Received on Thu Oct 30 2003 - 13:22:39 CST

This message: [ Message body ]
Next message: Uwe Weber: "Re: oracle and linux"
Previous message: Daniel Morgan: "Re: Chubb Institute for Training"
In reply to: Ken Denny: "Re: sqlplus does not display time portion from a date column"
Next in thread: Michel Cadot: "Re: sqlplus does not display time portion from a date column"

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