Support for Oracle 9i TIMESTAMP and INTERVAL types

[cswords]

Does Crystal Reports 8.5 support the following Oralce 9i datatypes:

TIMESTAMP
INTERVAL DAY TO SECOND

I have an Oracle database table which contains data of this type, but when I display the data in a Crystal report, the field is blank.

 

[AnnetteH]

CR 8.5 does not support the Oracle Timestamp or Interval data types. Neither does 9.0 or 10. I haven't checked XI yet.

You'll need to create a view that changes the datatype to Date and Integer respectively to use those fields.

 

[cswords]

My main purpose of using TIMESTAMP and INTERVAL is to calculate the difference between two timestamps WITH FRACTIONS OF A SECOND.

If I create a view with the TIMESTAMP converted to DATE and INTERVAL converted to integer, how do I maintain the fractional seconds?

Thanks so much for your help.

FYI: I have a call into Crystal Reports to see if they support these datatypes in XI. I'll let you know what they say!

 

[AnnetteH]

I experimented a little with XI. Timestamps from an Oracle 9.2 database are coming through OK, but as DateTimes. The fractional seconds are lost.

If you need a computation that returns fractional seconds, you'll have to do it in a view or stored procedure. (I think you'd have to do that anyway, since I don't believe there is any Crystal function that will give you the difference in two dates including fractional seconds.)