I have the below table with data – I want to create a query that displays the employees that had previous job as student and were then converted to “Employee” even if the final status is ACTIVE/INACTIVE I want to create a query that displays the below employees – The above output, should show if previous job has anyting like
Tag: bi-publisher
How do I fix ORA-01843: not a valid month?
So at the query level, I have it: And I’ve tried looking at a few articles with one most notable: How to change the date format in Oracle BI Publisher? I have also tried using: While going through structure and XML I noticed my date is in string format: element name=”DATETIME” value=”DATETIME” label=”DATETIME” dataType=”xsd:string” breakOrder=”ascending” fieldOrder=”3″ So I removed the