SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

default precision for type timestamp oracle sql

2679576Oct 12 2015 — edited Oct 12 2015

Hi,

i am reading the book of advanced sql of oracle 11g. I found that the default precision of the type timestamp is 6. but when i tried an example i have the following result: 21-JUN-99 12.00.00.000000000 AM ( we have 9 zero) i didn't understand that. Please could you help me

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 9 2015

Added on Oct 12 2015

2 comments

831 views