Re: How to fix the timing format in SQL*Plus, 8i?

rembus_at_mail.ru (Unemployed in the Valley) writes:

> How do I get rid of that:
>
> set timimg on
> exec myproc;
>
> PL/SQL procedure successfully completed.
>
> Elapsed: 01:111:6690.60
> ========
>
> Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.6.0.0 - Production
>
>
> I would rather prefer 01:51:18, the way it used to be before 8i.
> Is there a method to format this?

The format is not changeable but there should not be three digits between the colons. This Windows specific problem was resolved in SQL*Plus 9.0.1. If you have access to Metalink bug information, refer to bug 1320358 and bug 2487103.

Chris

-- 
Christopher Jones, Oracle Corporation, Australia.