When I run my sql there is no such error "not valid month" but when I'm using tableau and want to change from live data to extract data I will having this error message.
An error occurred while communicating with data source 'MY DATA SOURCE NAME' Bad Connection: Tableau could not connect to the data source. Error Code: 3834A5EA Oracle database error 1843: ORA-01843: not a valid month Unable to create extract
I tried to change my date format in sql become trunc(date) but still having error in Tableau.