Hi,

In database_properties table date format is in 'DD-MON-RR', but in table it showing different format in date columns.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt
ions

SQL> select * from database_properties where PROPERTY_NAME = 'NLS_DATE_FORMAT'
2 ;

PROPERTY_NAME
--------------------------------------------------------------------------------

PROPERTY_VALUE
--------------------------------------------------------------------------------

DESCRIPTION
--------------------------------------------------------------------------------

NLS_DATE_FORMAT
DD-MON-RR
Date format


SQL> SELECT created,last_ddl_time,TIMESTAMP FROM dba_objects WHERE object_TYPE =
'TABLE' AND object_name = 'LINK$';

CREATED LAST_DDL_ TIMESTAMP
--------- --------- -------------------
12-MAY-00 23-FEB-15 2015-02-23:20:38:43

SQL>

it suppose to show in format there in "database_properties" table but its not showing like that.

SQL> create table t as select sysdate d from dual;

Table created.

SQL>
SQL> select * from t;

D
---------
22-AUG-17

1 row selected.

SQL>
SQL> alter session set nls_date_format = 'yyyy/mm/dd';

Session altered.

SQL>
SQL> select * from t;

D
----------
2017/08/22

1 row selected.

SQL>
SQL> alter session set nls_date_format = 'dd/mm/yyyy hh24:mi:ss';

Session altered.

SQL>
SQL> select * from t;

D
-------------------
22/08/2017 11:34:33

1 row selected.