import CSV with one field is date into HSQL DB

[java_user]

I have CSV file like below.
Mon Jul 14 00:00:12  2008,aa,1
Mon Jul 14 00:00:12  2008,bb,199
Mon Jul 14 00:05:13  2008,aa,1
Mon Jul 14 00:05:13  2008,bb,202
Mon Jul 14 00:10:12  2008,aa,1
Mon Jul 14 00:10:12  2008,cc,1
Mon Jul 14 00:10:12  2008,aa,202
Mon Jul 14 00:15:12  2008,bb,1
Mon Jul 14 00:15:12  2008,cc,199
Mon Jul 14 00:20:14  2008,dd,1
Mon Jul 14 00:20:14  2008,ee,199

here the delimiter is "," and i want to import above CSV into HSQL DB. could you please help me how to do that ?

[fredt]

As the date is not in the standard SQL format, you should define the field
as a VARCHR field in the table.

It would be easy to write a java program to convert it into the recognised
date format, e.g. 2008-07-14 00:10:12, before you import int HSQLDB.

Fred

----- Original Message -----
From: "java_user" <chramesh19@...>
To: <hsqldb-user@...>
Sent: 21 July 2008 11:04
Subject: [Hsqldb-user] import CSV with one field is date into HSQL DB



I have CSV file like below.
Mon Jul 14 00:00:12  2008,aa,1
Mon Jul 14 00:00:12  2008,bb,199
Mon Jul 14 00:05:13  2008,aa,1
Mon Jul 14 00:05:13  2008,bb,202
Mon Jul 14 00:10:12  2008,aa,1
Mon Jul 14 00:10:12  2008,cc,1
Mon Jul 14 00:10:12  2008,aa,202
Mon Jul 14 00:15:12  2008,bb,1
Mon Jul 14 00:15:12  2008,cc,199
Mon Jul 14 00:20:14  2008,dd,1
Mon Jul 14 00:20:14  2008,ee,199

here the delimiter is "," and i want to import above CSV into HSQL DB. could
you please help me how to do that ?
--
View this message in context:
http://www.nabble.com/import-CSV-with-one-field-is-date-into-HSQL-DB-tp18565549p18565549.html
Sent from the HSQLDB - User mailing list archive at Nabble.com.


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great
prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user 


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user