creation date

Hi,

On 11.2.0.4 on AIX

I run

SQL> select max (to_char(created,'dd/mm/yy hh24:mi:ss')) from dba_objects where status='INVALID';

MAX(TO_CHAR(CREAT

-----------------

23/10/23 12:09:41

But when I run

SQL> select created, object_name, object_type from dba_objects where status='INVALID' and created in (select max(created)from dba_objects where status='INVALID');

CREATED   OBJECT_NAME               OBJECT_TYPE

--------- ---------------------------------------- -------------------

14-NOV-23 SYN1           SYNONYM

14-NOV-23 SYN2          SYNONYM

Why creation date is not 23/10/23 even if the condition was:

where created in (select max(created)from dba_objects where status='INVALID');

Thanks for explanation.