James Masters wrote:
Hi James
But if I choose the NOT NULL route, then surely I will still need a special
check i.e. if ($date ne '-00-00')
To me the latter sounds like a slighly more contrived check, no?
No. It's not that simple.
--
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/
But if I choose the NOT NULL route, then surely I will still need a special
check i.e. if ($date ne '-00-00')
RDBO uses DateTime to handle it's objects I believe. YMMV but I think
it may handle the -00-00 case under the hood.
regards,
Danial
On 3/15/07 6:14 AM, Danial Pearce wrote:
But if I choose the NOT NULL route, then surely I will still need a special
check i.e. if ($date ne '-00-00')
RDBO uses DateTime to handle it's objects I believe. YMMV but I think
it may handle the -00-00 case under the hood.
-00-00
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
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
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 NULL