Skip to Content
Former Member
Oct 18, 2007 at 09:38 PM

Problems inserting date values in Oracle 10g


Hi All,

I'm having SERIOUS problems trying to insert a simple date value in my oracle.

I did this one million times before in xMII 11.5, but now it appears that doesn't work anymore!

Here are some info:

Data Server Config:

Date Prefix: TO_DATE('

Date_Sufix: ', 'MM/DD/YYYY HH24:MI:SS')

Internal Date Format: yyyy-MM-dd HH:mm:ss

In my Query Template:

Date and Time Format: MM/dd/yyyy HH:mm:ss

In my Transaction

Parameter: datefromxmlformat(datenow, "MM/dd/yyyy HH:mm:ss")

I also tried change the parameter to datenow, no success.

I tried to change the Query Template format, no success.

Finally, I tried to change my Date prefix & sufix, no success too.

I really don't know what else I can do. I would appreciate some help.

PS: I'm using xMII 12.0.1 with ojdbc14.jar

Thanks in advance.

Pedro Sena