How to set a MySQL TIMESTAMP to null
Fernand Vanrie <[email protected]> Thu, 24 Jun 2010 14:09:53 +0200
| Newsgroups | gmane.comp.openoffice.dba.devel |
|---|---|
| Message-ID | <[email protected]> |
Hallo all Windows 00 3.2.1 MySQL as dbsever native connector we use a "preparedstatement" to update a mySQL table with a timestamp column and text columns oStatement.setNull(1,1111 ) for a "textfield" works fine (1111 = long SQLType "others") oStatement.setNull(2,1111 ) for a "timestamp" returns "00-00-00 00:00:00" and not the Mysql (null) i tried SQLtype 0 also with same results Thanks for any hint Fernand