(as Strings), but with HSQLDB text files I have to use "2004-06-03 0:0:0" for the same
effect. "2004-06-03" works fine for date fields, limitations is only for timestamp fields.
If this is the desired behavior, I'd like to document this in the Guide. I'd prefer for it to
have useful defaults like normal JDBC. I have a purchase date and a sale date. I usually
(but not always) do not have the time of day for purchase date. The people entering the
data into their spreadsheet have to add " 0:0:0" for every purchase date, otherwise the
text table chokes when the spreadsheet export is added to the text file. (I really don't
want to complicate the procedure by massaging the data in between).
-- ICF: 703-934-3692 Cell: 703-944-9317
------------------------------------------------------- This SF.Net email is sponsored by the new InstallShield X.
From Windows to Linux, servers to mobile, InstallShield X is the one
installation-authoring solution that does it all. Learn more and evaluate today! http://www.installshield.com/Dev2Dev/0504 _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers