ISO 8601 date format

texlnghorn

• October 08, 2008 00:00

• Answered

Follow

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?

• 

  dpavlis

  • April 09, 2009 19:46

  0

  Comment actions Permalink

  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.

Please sign in to leave a comment.