We are having problems sorting the files in all our directories in AWS Oracle RDS.
Listing the files using e.g. SELECT * FROM TABLE(rdsadmin.rds_file_util.listdir(p_directory => 'BDUMP')); they all get the same MTIME (always todays date):
dbtask-1661988786367-24417.log file 460 05.09.2022 00:00:00
dbtask-1661810723182-22532.log file 902 05.09.2022 00:00:00
There are examples on several sites/blogs/forums that show MTIME in dd.mm.yyyy hh24:mi:ss (or similar) format.
The AWS support has been less than helpful so far.
Anyone got a clue what is happening here?
