19c patch time group missing from repository view
When run the below query
SELECT distinct b.property_value
FROM mgmt$target a JOIN mgmt$target_properties b
ON a.target_name = b.target_name
AND a.type_qualifier3 = 'DB'
AND b.property_name = 'DBVersion'
I receive a return of values as such:
12.1.0.2.190416
12.2.0.1.191015
19.8.0.0.0
12.2.0.1.200714
12.2.0.1.190716
12.2.0.1.200414
19.7.0.0.0
11.2.0.4.180717
12.1.0.2.190716
12.1.0.2.200714
19.9.0.0.0
18.10.0.0.0
11.2.0.4.191015
12.1.0.2.180717
Almost all 11g and 12c versions have a six digit date time group in the last decimal place. However, this does not appear for 19c versions. I am trying to create a view that converts the time group into a more readable date view and then count the number of databases by respective patch release date. I cannot do this for the 19c databases because it does not follow the same format. Is this a configuration issue on our end our with Oracle. I observed in this Oracle document linked