Spunk Inc response from Case #252924:
In regards to the error code "ora-01843" this error is due to an invalid month format. The date you specified in your sample is an invalid month. Valid months are: January-December, for format code MONTH, and Jan-Dec, for format code MON. The reason a ORA-01843 occurs includes these reasons
• Using an incorrect NLS_DATE_FORMAT
This happens a lot when you see data coming from US
(where the Month is normally written before the day)
but the format in the application is still the "European" style.
(where the day is written before the month).
· Using a incorrect NLS_DATE_FORMAT:
Such as trying to insert a "written" month name but are using a "numeric" month in the mask
Based on that, I made the changes below which worked for me:
Previous
| convert timeformat="%Y-%m-%d %H:%M:%S" ctime(startTime)
Current
| convert timeformat="%Y-%m-%d %H:%M:%S" mktime(startTime)
| fieldformat startTime=strftime(startTime,"%d-%B-%Y %I:%M:%S")
... View more