Crystal Reports 9 and Oracle 'WITH LOCAL TIME ZONE' supported?
Hi,
CR v9 erroneously creates the Oracle 'WITH LOCAL TIME ZONE' as string[5]
datatype instead of timestamp or date.
Does anyone know if there is a workaround or a HotFix for this? This
datatype was introduced in Oracle 9i
Works fine in CR xi
I have tried asking in the Business Objects forums but there was no reply.
Thanks,
siegfried
.
Relevant Pages
- Re: Getting date/time fields from Oracle with ADO
... The Oracle Enterprise Manager is showing DATE, ... "DATE" datatype and not "TIMESTAMP"? ... > Mulitple-step OLE DB operation generated errors. ...
(microsoft.public.vb.general.discussion) - Re: problems inserting a utf8 timestamp with DBD::Oracle
... Don't think so as I'm not using Oracle 9. ... Well I'm not saying it isn't a bug in Oracle but this one is a real problem I cannot easily workaround as really I need a timestamp and a date. ... Client is Oracle 10.2.0 XE ... If you then comment out the 2nd block of code and uncomment the 3rd block of code it works i.e it appears it does not like having a timestamp and a date in the same insert. ...
(perl.dbi.users) - Re: question about substr
... Oracle then compares the values character by character up to the first ... CHAR, NCHAR, text literals, or values returned by the USER function. ... What is the datatype of substr? ...
(comp.databases.oracle.server) - Re: suggestions sought on returning rows from oracle proc and deleting them in same proc
... this is not Perl stuff but Oracle PL/SQL. ... deleting them in same proc ... create mytable (id int, created timestamp); ... Perl calls the first one to get the unique ids and the timestamp ...
(perl.dbi.users) - Re: Date different
... >> oracle changed the default types returned for their newest oracle drivers, ... What is going on with DATE and TIMESTAMP? ... The more obvious mapping to java.sql.Date was somewhat ... You set the system property by including a -D option in your java command ...
(comp.lang.java.programmer) |
|
