SET DATEWIDTH

[Stroeks]

Hi,

I am using PL/SQL developer 5.1.4.
I found the SET DATEWIDTH command, but the result is a bit surprising to me:

SET DATEWIDTH 20

select * from p12025.testen;

ID DATUM
------------------------- --------------------
1 13-06-2004 08:40i:23

What does the i tell me? 08:40i:23

thank you

Leo Soepenberg.

 

[Marco Kalter]

The i tells you that you have specified an incorrect time-format (Tools > Preferences > Date/Time tab page). For the date and time format you must use the Windows formatting rules.