Forum Stats

  • 3,855,143 Users
  • 2,264,464 Discussions
  • 7,905,908 Comments

Discussions

Value of SNAPSHOT_TIME in DBA_PDB_SNAPSHOTS

user6327254
user6327254 Member Posts: 5 Blue Ribbon
edited Jun 4, 2018 4:49PM in Multitenant

The 18c documentation says that DBA_PDB_SNAPSHOTS.SNAPSHOT_TIME is a timestamp (in the description)

https://docs.oracle.com/en/database/oracle/oracle-database/18/refrn/DBA_PDB_SNAPSHOTS.html#GUID-B1389923-0F82-476F-BBEE-…

However, the actual datatype is NUMBER.

So my question is - is there any way to convert this number into a date or timestamp value?

Answers

This discussion has been closed.