This content has been marked as final. Show 3 replies
To your first question, I think OO4O is still supported in 9i.
The OO4O date formats are usually controlled by the regional settings for Windows (OO4O uses an OLEDate data type behind the scenes). The COM/OLE settings are applied after the NLS setting at the OCI level.
Thanks for the replies. I found the newest version and installed it and still had the problem with dates. I think it stems from the way the date format strings are setup in the regional settings. You specify the date and time formats as two separate strings- one for date and one for time. OO4O must be looking at only the date string. I decided to 'step around' the problem and store my dates as strings and deal with it later. :)
One of the things I tried was to use the date variant type to populate the field. But that failed too. Oh well!