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
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center