Skip to Main Content



For appeals, questions and feedback about Oracle Forums, please email Please ask technical questions in the appropriate category. Thank you!

Issues with XML data source timestamp

User_EN047Nov 8 2021

I am trying to convert [Add Current Date] palette's default MON-DD-YYYY to YYYY-MM-DDTHH:MI:SS. After that, I'll have to write/export this 'new', converted syntax, to a specific table in a database. This table will only accept the YYYY-MM-DDTHH:MI:SS format as a date. I'm currently getting null values in my date column, in the database.
I've tried using [Convert Date to String] palette, but this doesn't work. Regardless, I'll still need to change whatever transformed format to a date, because the code for the table, is accepting YYYY-MM-DDTHH:MI:SS as a date. Any suggestions??
Is there a way of writing a SQL statement to force the default MON-DD-YYYY from the [Add Current Date] palette, to be converted to YYYY-MM-DDTHH:MI:SS?

Post Details
Added on Nov 8 2021
1 comment