Have a look at
ADDDATE() and SUBDATE()
mysql> SELECT DATE_ADD("1997-12-31 23:59:59",
-> INTERVAL 1 DAY);
-> 1998-01-01 23:59:59
DATE_FORMAT(date,format) will also be very helpful to
use in your queries, allowing you to return your mysql
date in a human friendly format of choice.
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
olinux
--- John Fishworld <[EMAIL PROTECTED]> wrote:
> Okay so I've then got
>
> 2002-05-08
> and whats then the best way to manipulate it
> regarding
> plus 3 days or plus 4 weeks ?
>
>
>
>
> > > lol ! no thats not what I meant !
> > > what's best to put into MySQL
> > > datetime from MySQL
> > > now()
> > > or from php date !
> > >
> > > Regarding the format - its a german site so not
> expecting many yanks
> there
> > > !
> >
> > Sorry :)
> >
> > In that case it's best to stick to mysql's native
> format.
> >
> > --
> > Jason Wong -> Gremlins Associates ->
> www.gremlins.com.hk
> > Open Source Software Systems Integrators
> > * Web Design & Hosting * Internet & Intranet
> Applications Development *
> >
> > /*
> > I use not only all the brains I have, but all
> those I can borrow as well.
> > -- Woodrow Wilson
> > */
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit:
> http://www.php.net/unsub.php
> >
> >
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
