Issue
When using the DATE() function in a calculated field with an Oracle data source, the following error might occur:ORA-01861: literal does not match format string
Last Modified Date: 24 Aug 2022
ORA-01861: literal does not match format string
Environment
- Tableau Desktop
- Oracle
Resolution
Use the DATEPARSE() function instead of the DATE() function.For example, if the DATE() calculation is
DATE( STR ([Year]) + "-" + STR([Month]) + "-1" )
The matching DATEPARSE() calculation would be
DATEPARSE("yyyy-MM-dd", (STR ([Year]) + "-" + STR([Month]) + "-1" ))
Cause
This error occurs when a literal is entered with a format string, but the length of such format string is not the same as the literal. This can sometimes occur in Tableau Desktop when using the DATE() function along with an Oracle database.Additional Information
For more information about this error message, see Oracle / PLSQL: ORA-01861 Error Message.Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials