I thought I would post this quick blog to try and help anybody out who may come across the same issue as I did.
When trying to do some data preparation via filtering on a date in the "Predict" tab of SAP Predictive Analysis, I received the following error when trying to run the analysis: "An error occurred while executing the query.Error details: SAP DBTech JDBC: [266]: inconsistent datatype: 3-3-2014 is not a DATE type const: line 1 col 779 (at pos 778)". The error with a different format is the same:
Unfortunately, this error is vague and does not point out what a valid date format is or where to find the valid date formats. I tried multiple formats until I stumbled upon one that works (ie, YYYY-MM-DD):
Hopefully this helps some people out.
If you know of documentation or other date formats that are supported, please share!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
40 | |
25 | |
17 | |
13 | |
8 | |
7 | |
7 | |
7 | |
6 | |
6 |