Skip to Content
0
Former Member
May 09, 2013 at 08:08 PM

Oracle 10g timestamp field

25 Views

Hi,

We are using BO XIR3.1 and just came across an issue whereby when using a Oracle Timestamp field in a query filter, we get an oracle error of cannot of invalid month. The only way I see of resolving this is by converting the value to a MM/DD/YYYY HH:MI:SS in the Object SQL (e.g. TO_DATE(TO_CHAR(TIMESTAMP_COLUMN,'MM/DD/YYYY HH:MI:SS'),'MM/DD/YYYY HH:MI:SS')) . Is there a way of resolving this without adding this extra logic to the Object SQL? I know it used to be an issue with XIR2 but I am wondering if its resolved with XIR3.1.

Thanks

Nilesh