strange time fraction in date

[bataille]

In a SQL window I keep seeing a strange time fraction of a date. A date like '03-MAR-2003 13:33:36' is displayed as '04-MAR-2003 1324:33i:36'.
This does not happen in the command window.
Changing the date-time format in the Preferences menu does not change this behaviour. It happens with 8.0.6 and 8.1.7.2 databases.
My PL/SQL version is versie 5.1.0.656
Any ideas?

Regards, Joost

 

[Marco Kalter]

This error does indicate that the date format and/or time format in Tools > Preferences > Date/Time is set to "User Defined", and that the actual format does not comply with the Windows date format options. Perhaps you have used a Oracle format instead?

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

 

[bataille]

Originally posted by mkalter:
This error does indicate that the date format and/or time format in Tools > Preferences > Date/Time is set to "User Defined", and that the actual format does not comply with the Windows date format options. Perhaps you have used a Oracle format instead?

Thanks, Marco. Changing the time format to 'Windows format' fixed it.
Regards, Joost