ISO 8601 date format

CloverDX Platform
1

Sorry for the repost, I posted this in the wrong forum.

I am trying to insert a date that is in the ISO 8601 format which is of the form YYYY-MM-DDThh:mm:ss. There is a T that separates the date and time. Clover does not recognize this format. I am trying to insert this into an oracle table. Oracle will let you ignore characters in a date format by escaping them with a double quote. So you could say to_date(‘2008-10-08T12:00:00’,‘YYYY-MM-DD"T"HH24:MI:SS’). I tried using this to_date format with Clover but it failed. I’m guessing it did not like the double quotes. Any ideas?

2

Hello,
clover can handle dates only with java format, and the T character is illegal pattern character. But this should work clover string data field.