Hi Wolfgang,
here is an extract from the hsqldb documentation
http://hsqldb.org/web/hsqlDocsFrame.html
*
A DATE literal starts and ends with ' (singlequote), the
format is yyyy-mm-dd (see java.sql.Date.
*
A TIME liteal starts and ends with ' (singlequote), the
format is hh:mm:ss (see java.sql.Time).
*
A TIMESTAMP or DATETIME literal starts and ends with '
(singlequote), the format is yyyy-mm-dd hh:mm:ss.SSSSSSSSS
(see java.sql.Timestamp).
When specifying default values for date / time columns in CREATE
TABLE statements, or in SELECT,INSERT, and UPDATE statements,
special SQL functions: NOW, SYSDATE, TODAY, CURRENT_TIMESTAMP,
CURRENT_TIME and CURRENT_DATE (case independent) can be used. NOW
is used for TIME and TIMESTAMP columns, TODAY is used for DATE
columns. The data and time variants CURRENT_* are SQL standard
versions and should be used in preference to others. Example:
CREATE TABLE T(D DATE DEFAULT CURRENT_DATE);
CREATE TABLE T1(TS TIMESTAMP DEFAULT CURRENT_TIMESTAMP);
Binary data starts and ends with ' (singlequote), the format is
hexadecimal. '0004ff' for example is 3 bytes, first 0, second 4
and last 255 (0xff).
Any number of commands may be combined. With combined commands, ';'
(semicolon) must be used at the end of each command to ensure data
integrity, despite the fact that the engine may understand the end of
commands and not return an error when a semicolon is not used.
May be this helps. Another way would be to create a prepared statement.
-- OJ
Wolfgang Schaible wrote:
hi,
oStmt.executeUpdate("UPDATE "+sJM+ " SET ISPAID= whatever
results in 'wrong datatype'... (Set a not empty date works)
Thanks for an idea
Wolfgang
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Nagelsweg 55 mailto:[EMAIL PROTECTED]
D-20097 Hamburg http://www.sun.com/staroffice
Example isn't another way to teach,
it is the only way to teach.
Albert Einstein
