Re: How to set a MySQL TIMESTAMP to null
Peter Eberlein <[email protected]> Thu, 24 Jun 2010 16:51:54 +0200
| Newsgroups | gmane.comp.openoffice.dba.devel |
|---|---|
| Message-ID | <[email protected]> |
Hi Fernand,
did you query for the type of the column?
resultSet.columns.getByName("myCol").Type?
> 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
>
>
Regards
Peter