Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. 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?

Comments
Post Details
Added on Nov 8 2021
1 comment
69 views