Oracle/SAP converting dates from SAP to ORACLE and back
From: WillBrenn <bill_brennum_at_grainger.com>
Date: 10 Feb 2003 08:19:48 -0800
Message-ID: <581021b7.0302100819.27d7f172_at_posting.google.com>
Date: 10 Feb 2003 08:19:48 -0800
Message-ID: <581021b7.0302100819.27d7f172_at_posting.google.com>
Hi,
I am currently connecting to an external Oracle database using SAP.
My issue is with Oracle's DATE type and converting it to SAP's
DATS/TIMS types. SAP stores its DATS type in an Oracle VARCHAR2(8) in
the format 'yyyymmdd' while
it stores its TIMS type in a VARCHAR2(8). I attempted to use a
TO_CHAR function on a date field but it renders the view read-only.
I am looking for anyone who has an idea on how to translate date datatypes from Oracle to SAP. Any and all ideas welcomed.
Thanks.
Bill Received on Mon Feb 10 2003 - 17:19:48 CET