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