No support for Timestamp datatype in BO XI R2

[Former Member]

There is no support for using Timestamp datatype in BO XI R2. I am using Oracle10g which has column as Timestamp but we are not able to extract the fractional precision of timestamp datatype

Following code we are using for an object defined as Date in the universe but it only provides precision till seconds. We are not able to get the fractional precision.Just to clarify by fractional part I meant the last 6 digits for: 07/08/2003:11:22:57:000000

Existing Code:

(extract(DAY FROM Table1.END_TIME-Table1.START_TIME)2460*60)+

(extract(HOUR FROM Table1.END_TIME-Table1.START_TIME)6060)+

(extract(MINUTE FROM Table1.END_TIME-Table1.START_TIME)*60)+

(extract(SECOND FROM Table1.END_TIME-Table1.START_TIME))

Is there any support available from BO to cater this issue?

Edited by: Anshuman Kumar on Apr 13, 2010 10:50 AM

[Former Member]

Well after reloading the data with 6 digits after the decimal points after seconds example:05-MAR-10 04.31.34.132222 AM , I have observed that the extract function which has been mentioned above is working fine to capture the milliseconds record.

Now my concern is to display the milliseconds data in the report. To provide the exact details I am listing an example:

Data in Database are:

End_Time:05-MAR-10 04.31.34.132222 AM

Start_Time:04-MAR-10 04.31.34.231111 AM

End_Time - Start_Time:86399.90111

Data in BO Report are:

End Time:03/04/2010 04:31:34 AM

Start Time:03/05/2010 04:31:34 AM

Run Time:86399.90111

What format settings should be used in the report to display End Time exactly the way it is in the database.

I have already tried the following options but nothing has worked so far:

1)'MM/dd/yyyy hh:mm:ss.ms A'

2)'MM/dd/yyyy hh:mm:ss.ssssss A'

3)'MM/dd/yyyy hh:mm:ss.FFFFFF A'

4)'MM/dd/yyyy hh:mm:ss.ffffff A'

Appreciate your suggestions