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?
CloverETL as of version 2.7 uses new library for parsing Dates. It greatly extends the previous one (standard Java library) which should allow to use the “T” in date pattern/format.