Depends what you want to use to get at it,
but pl/sql will happily read a "short long"
into a varchar2(). So one option is to
write a pl/sql function which reads the
long, extracts the date you want, and
returns it as a date.
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Mark Brady wrote in message
<194588b5.0203071221.29fc84e4_at_posting.google.com>...
>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 - 15:09:45 CST
