[RDBO] Beginner q. on date

I'm converting an old textual database to MySQL with Rose. MySQL has 3 options for a date: a date -00-00 NULL My scripts currently have a date either as "" or a date. So presumably my empty date "" needs to be mapped to either -00-00 or NULL in MySQL. I've searched the documentation wit

Re: [RDBO] Beginner q. on date

Hello James, > I've searched the documentation without finding anything and although there > are a couple of threads on this subject it's still not clear to me. In my > date fields in MySQL schema, is it best for me to allow NULL and then make > empty dates map to NULL? Or is it best to disallow

Re: [RDBO] Beginner q. on date

On Mar 13, 2007, at 12:14 PM, James Masters wrote: > I'm converting an old textual database to MySQL with Rose. > > MySQL has 3 options for a date: > a date > -00-00 > NULL my suggestion: don't declare your date column as "NOT NULL" , when migrating , convert -00-00 to NU

Re: [RDBO] Beginner q. on date

Hi James > I've searched the documentation without finding anything and although > there > are a couple of threads on this subject it's still not clear to me. In my > date fields in MySQL schema, is it best for me to allow NULL and then make > empty dates map to NULL? Or is it best to disallow N