Saturday, November 29, 2008

Re: REgarding using Mysql functions like NOW(), CURDATE() etc

I don't think Federico has answered your general question about using
MySQL functions, and neither can I - but on the up side, I think that
Federico's query will perform better than using CURDATE() ;)

On Nov 29, 4:20 pm, "Federico Rinaldi" <federicorina...@gmail.com>
wrote:
> Have you tried with:
>
> $this->data['User']['signedup'] = date("Y-m-d");
>
> FedeX
>
> On Sat, Nov 29, 2008 at 12:23 PM, Malcolm Krugger <
>
> chennaiprogram...@gmail.com> wrote:
>
> > I maybe missing the obvious, But can someone please point the right
> > syntax for
>
> >                                                $this->data['User']
> > ['status'] = 'temp';
> >                        $this->data['User']['signedup'] = 'CURDATE()';
> > $this->User->save($this->data)
>
> > The above does not save the current date..
>
> > ALso I tried
>
> >                        $this->data['User']['signedup'] = '!-CURDATE()';
>
> > But the same results
>
> > Can anyone help ?
>
> > Malcolm
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

No comments: