Discussion can be found at:
SQLTOOL as of 2011-06-15 ( HSQL Version 2.4.2 ) when using DSV to Import ( \m ) from a DSV file, and, the field type in the database is defined as TIME, the text for the TIME must include a DATE and space prior to the time ( for example: 1899-01-01 07:23:53 ). However, just a time of: 07:23:53 will result in an error.
I would suggest adding to the SqlTool documentation this situation and work-around, and, whenever possible, allowing SqlTool to 'accept' just a time format for a database field defined as TIME.
Log in to post a comment.