1 Reply Latest reply on Mar 24, 2012 1:54 AM by meser

    How to convert high_value to date data type on dba_tab_partitions

    Siva Ora
      I just want to query and get the max date available on the dba_tab_partitions for the high_value field.

      high_value data type is LONG it has the value for Partition bound value expression.

      For example on my partition table the expression is like TO_DATE(' 2012-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')

      I just want to convert the high_value to date data type.