I realise now that the actuall error was caused by a missing zero in one of the entries. i.e. I had put 1 and not 01 for the day field. With 01 in place, it works for yyyy-MM-dd also.
Thanks. pjames wrote: > > Thanks Matt. That hint did help. Though MM/dd/yyyy didnt work for me, > MM-dd-yyyy did work. Thanks a lot. > > > > mraible wrote: >> >> I would try MM/dd/yyyy as your date format. >> >> Matt >> >> On Wed, Jul 30, 2008 at 5:22 AM, pjames <[EMAIL PROTECTED]> wrote: >>> >>> Hi, >>> I am trying to import a 'datetime' value to my mysql db from >>> sample-data.xml using dbUnit. Here is the file sample >>> <value><![CDATA[2008-07-01 00:00:00.0]]</value>. But the proces fails >>> with a >>> casting error. Can someone point out how can i make date imports work >>> with >>> sample-data.xml? >>> >>> >>> Thanks in advance! >>> !J >>> -- >>> View this message in context: >>> http://www.nabble.com/Problem-with-dbUnit-test-data-import-from-file-tp18731093s2369p18731093.html >>> Sent from the AppFuse - User mailing list archive at Nabble.com. >>> >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: [EMAIL PROTECTED] >>> For additional commands, e-mail: [EMAIL PROTECTED] >>> >>> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> > > -- View this message in context: http://www.nabble.com/Problem-with-dbUnit-test-data-import-from-file-tp18731093s2369p18847283.html Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
