G
Guest
Hi,
I'm trying to use MySql 4.1 db instead of MSSql2k and am having problems
with the DateTime in the db.
In mysqladmtools 1.0.19 I'm recommended to use 0000-00-00 00:00:00 as the
default value, but you can't save these settings. If you read the manual they
say the default value is thbe one above but that you can't use it, you have
to use a non zero value and with a non zero value you can't save the
settings. Pandoras box?
So far my solution has been to programmatically insert non zero datetime
values in every record. And it works just fine.
In my apps I'm using projects with a startdate and an enddate, and you don´t
want to see a non zero datetime value as the enddate so in mssql2k you could
use a SqlDateTime.Null value and save with db.null. Is there a ecvivalence in
MySql?
TIA
Kenneth P
I'm trying to use MySql 4.1 db instead of MSSql2k and am having problems
with the DateTime in the db.
In mysqladmtools 1.0.19 I'm recommended to use 0000-00-00 00:00:00 as the
default value, but you can't save these settings. If you read the manual they
say the default value is thbe one above but that you can't use it, you have
to use a non zero value and with a non zero value you can't save the
settings. Pandoras box?
So far my solution has been to programmatically insert non zero datetime
values in every record. And it works just fine.
In my apps I'm using projects with a startdate and an enddate, and you don´t
want to see a non zero datetime value as the enddate so in mssql2k you could
use a SqlDateTime.Null value and save with db.null. Is there a ecvivalence in
MySql?
TIA
Kenneth P