ORA-01847: day of month must be between 1 and last day of month

[Former Member]

i am doing a idoc2jdbc scenario。

DB is oracle。

there is a error in audit log of RWB.

ORA-01847: day of month must be between 1 and last day of month

the other scenario is same as the scenario. that is OK.

but, the scenario has error.

my message date feild as follows:

<DATE hasQuot="No">TO_DATE('2010-06-29 15:53:39','yyyy-mm-dd hh24:mi:ss')</DATE>

have anybody run into the error?

[Former Member · Accepted solution]

check this query on your database.

is it returning the same error.

Select TO_DATE('2010-06-29 15:53:39','yyyy-mm-dd hh24:mi:ss') from dual.

if not , it should not return the error.

Regards

Dragon.

[Former Member]

Try this -

TO_CHAR('2010-06-29 15:53:39', 'YYYY-MM-DD HH24:MI:SS.FF9')

Regards,

Neetesh