Not a Valid Month error with <2020-12-17 17:33:28> using Output Data node on Oracle OCI

[PaulFields2]

Not sure why I am getting this ORA-01843 error.  Timestamp field mapping is correct and format I'm using e.g. <2020-12-17 17:33:28> appears to be standard.  Any ideas?

[leon2020]

Seems it's recognising 2020-12-17 as the 12th day of the 17th month (and not 17th day of December).

May need to adjust the string or reformat the field..

[PaulFields2]

Have tried that - no luck.

If I were to use a DateTime field format, what's the standard string format to send a date time value to the db from Alteryx?  Not sure why this is so hard.

[PaulFields2 · Accepted solution]

OK - I figured it out.

e.g. 12-DEC-20 12.01.02.000000000 PM