RE: Convert Long to Date

["Powell, Mark D" <mark.powell@xxxxxxx>]

Use PL/SQL.  Read the long into a varchar2 and then perform a to_date on
the varchar2 variable into a date variable.  You can put this into a
user function if desired.
 

-- Mark D Powell -- 
Phone (313) 592-5148 

 


________________________________

        From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Brady, Mark
        Sent: Thursday, June 26, 2008 3:11 PM
        To: oracle-l-freelists
        Subject: Convert Long to Date
        
        

        Oracle stores the High Value of a Partition in a Long column. I
swear I've searched the friendly web, and I just can't figure out how to
get this long column converted back to a date or char I can take a char
to a date.

        

        If it exists on the web, please tell me. I don't know why this
is so hard to find.

        

        >>> This e-mail and any attachments are confidential, may
contain legal,
        professional or other privileged information, and are intended
solely for the
        addressee.  If you are not the intended recipient, do not use
the information
        in this e-mail in any way, delete this e-mail and notify the
sender. CEG-IP2

• References:
  • Convert Long to Date
    • From: Brady, Mark

Other related posts:

Convert Long to Date

RE: Convert Long to Date

RE: Convert Long to Date

Re: Convert Long to Date

RE: Convert Long to Date

Re: Convert Long to Date