date format in command window

[jtboyd]

i'm new to pl/sql developer from sql*plus. something that i relied quite often was the ability to see the time in timestamp records. i have the timestamp showing up correctly in the sql window, however it appears like this in the command window.

SQL> select sysdate from dual;

SYSDATE
-----------
03-Sep-03 1

any suggestions?

thanks,
jason

 

[Marco Kalter]

The Command Window does indeed truncate the date value, which is displayed incorrectly in your situation. We'll try to fix this.

------------------
Marco Kalter
Allround Automations

 

[01Maverick]

Originally posted by jtboyd:
i'm new to pl/sql developer from sql*plus. something that i relied quite often was the ability to see the time in timestamp records. i have the timestamp showing up correctly in the sql window, however it appears like this in the command window.

SQL> select sysdate from dual;

SYSDATE
-----------
03-Sep-03 1

any suggestions?

thanks,
jason

Hello,

Tri this
SQL> alter session set nls_date_format='DD/MM/RRRR HH24:MI:SS' ;
SQL> select to_char(sysdate) from dual;

TO_CHAR(SYSDATE)
-------------------
17/09/2003 09:18:50

Maverick

 

[Marco Kalter]

We have introduced a new SET DATEWIDTH command for the upcoming 5.1.4 patch release. This way you can set the width to correspond to the date/time format, without the need to use to_char.

------------------
Marco Kalter
Allround Automations