Skip to Content
0
Former Member
Apr 13, 2010 at 08:37 AM

No support for Timestamp datatype in BO XI R2

46 Views

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