Getting the date back from a Partition

TIA, I have tables which are range partitioned on a date. I name each partition PYYYYMMDD, therefore I can always translate the Partition name back to the date it represents. Easy.

I keep a rolling 2 month window by adding a new day's partition and exporting and truncating the 2-month old partition. I have two bounding partitions around this window. PMAX partion has a boundary date of Maxdate, so no data gets lost. PMIN which is the 'bottom' partition which keeps old data that may be added in error. PMIN has a High_Value of 2-months ago. How can I get back the date which it has for High_Value .

BTW:
High_Value in the User_Tab_Partitions table is a <i>LONG</i> data type.

Mark Received on Thu Mar 07 2002 - 14:21:06 CST