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?
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?
Please sign in to leave a comment.
Comments 1