That looks like a bug to me. I suggest you file this on trac. https://trac.cakephp.org/
On Thu, Jul 2, 2009 at 12:49 AM, calzone<[email protected]> wrote: > > So I have a form that collects information about an tentative > appointment, including the start time and end time. Both the start > and end time fields are mysql columns of type time (not datetime). > > My view file contains: > > echo $form->input('starts',array('label'=>'starts','interval'=>30)); > echo $form->input('ends',array('label'=>'ends','interval'=>30)); > > This renders correctly as two sets of dropdown fields, each with three > menus (hour, minute, and am/pm). > > If I make a time selection that is midnight (12:00 am) then cake > generates the following sql: > > INSERT INTO `inquiries` (`starts`, `ends`, `date`, `message`) VALUES > ('18:00:00', NULL, 1, '2009-07-13', 'Testing the inquiry system') > > As you can see, cake is translating the value of 12:00 am to NULL. I > assume this is because 12am is the same as 0, and 0 is being expressed > as NULL. > > On submit, my controller has nothing fancy, just: > > $this->Inquiry->create(); > if($this->Inquiry->save($this->data)) > > It works perfectly fine for all other time values. It's just midnight > that messes it up. > > Is this a bug? Or am I doing something wrong? > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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 -~----------~----~----~----~------~----~------~--~---
