Leading zero in the minute value of date fields are not shown when query is executing with F5 or 'Execute as Script option. If the minute value happens to be under ten, the leading zero of minutes is dropped in Output and Data tabs when query is executed with F5, such as below:
2009/01/16 12:2:45
The same query shows the following in SQLPlus:
2009/01/16 12:02:45
WORKAROUND:
None
STATUS:
Waiting for fix to be released in a future version of Toad for Oracle.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy