date

On 10 Jun, 16:16, Jordan wrote:
> J.O. Aho escreveu:
>
> > sim wrote:
> >> how can i add two date or  can get next date by adding 10 day like
> >> date()+10 in  date()+date() c, c++ or other lang.
>
> > strtodate("+10 days",time());
>
> >http://www.php.net/manual/en/function.strtotime.php
>
> How can I setup Mysql date to something like this 'dd/mm/YYYY'?
> I use Mysql v5.0
>
> JD.

See the DATE_FORMAT() function in the manual

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#fu...ion_dat
 >> Stay informed about: date 

J.O. Aho escreveu:
> sim wrote:
>> how can i add two date or can get next date by adding 10 day like
>> date()+10 in date()+date() c, c++ or other lang.
>
> strtodate("+10 days",time());
>
> http://www.php.net/manual/en/function.strtotime.php
>
>

How can I setup Mysql date to something like this 'dd/mm/YYYY'?
I use Mysql v5.0

JD.
 >> Stay informed about: date