Flashback Archive : can VERSIONS_STARTTIME be more precise than seconds ?
Hello,
I manage a database running on 11gR2 with Flashback Archive enabled for some tables.
I track the changes through Flashback Version queries like :
SELECT versions_startscn,
versions_endscn,
versions_xid,
versions_operation,
versions_starttime,
col1
FROM schema.t1
versions between scn 305797262 and 305797267
where col1= '62793';
But I can't manage to get the VERSIONS_STARTTIME with milliseconds. The better I get is, for example :
14-OCT-2020 16:33:23.000
or
14-OCT-2020 16:13:00.000
The documentation says that VERSIONS_STARTTIME is a TIMESTAMP column but maybe the Flashback Archive feature is not recording the date and time with milliseconds.
Do you know where I could find such information ?