Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

PaulFields2
8 - Asteroid

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?

 

3 REPLIES 3
leon2020
7 - Meteor

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
8 - Asteroid

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
8 - Asteroid

OK - I figured it out.

 

e.g. 12-DEC-20 12.01.02.000000000 PM

 

Labels