Jay,
You have a good idea which I think I should be able to incorporate. The
syntax that worked for me is -
UPDATE table_name SET `column_id`=NULL WHERE `column_id` = '-00-00';
Thanks for the suggestion!
David ...
On 12/17/2012 7:16 PM, Jay Lozier wrote:
On 12/17/2012 05:35 PM, receiver
On 12/18/2012 05:47 PM, receiver wrote:
Jay,
You have a good idea which I think I should be able to incorporate. The
syntax that worked for me is -
UPDATE table_name SET `column_id`=NULL WHERE `column_id` = '-00-00';
Thanks for the suggestion!
David ...
I thought UPDATE ... SET ... WHERE
Girvin's reasoning about dates is quite correct in my opinion. In our
case the zero valued date fields are logically NULLs and I would prefer
that the database store them as NULLs instead. I'm afraid it is MySQL
that is choosing to store zero values. The database in question is
being loaded
On 12/17/2012 05:35 PM, receiver wrote:
Girvin's reasoning about dates is quite correct in my opinion. In our
case the zero valued date fields are logically NULLs and I would prefer
that the database store them as NULLs instead. I'm afraid it is MySQL
that is choosing to store zero values.
] Value '-00-00' can not be
represented as java.sql.Date
Yes, that was something that naturally came to mind so I did try it and
it does solve the problem of the zero valued date. However, my
objective is to develop a database file (i.e., .odb) that I can send to
a community of users who
2012, 1:49
*Subject:* Fwd: Re: [libreoffice-users] Value '-00-00' can not
be represented as java.sql.Date
Yes, that was something that naturally came to mind so I did try it and
it does solve the problem of the zero valued date. However, my
objective is to develop a database