If you're using a particular version of phpmyadmin (i'm speculating on what you're using here) it will allow you to have a null field and still have a default value of '0000-00-00 00:00:00' in a datetime field. Make sure that default value didn't get left in there. I've had this happen.
On Oct 19, 1:39 pm, RLR <[EMAIL PROTECTED]> wrote: > Thanks for your reply Nate but the default value is defined as NULL > e.g. > > `recurring_date` datetime default NULL, > > Any other suggestions? > > On Oct 19, 9:32 pm, nate <[EMAIL PROTECTED]> wrote: > > > Change the default value of the column to NULL. > > > On Oct 19, 3:10 pm, RLR <[EMAIL PROTECTED]> wrote: > > > > I recently started using cakephp 1.2 branch. > > > > The problem I am having is that a date field in my app is always saved/ > > > reloaded with "0000-00-00 00:00:00". I would prefer to use a NULL > > > value when no date has been entered. How can I change/fix this > > > behavior? > > > > Thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
