date

[Alain Dhaene]

Hi,

I retrieve a date from the mysql database.

e.g 2004/12/02

How is it possible to make this day with 1 day higher : so I get 2004/12/03?

Thx,

Alain

[Ben Gribaudo]

Hi Alain,

How is it possible to make this day with 1 day higher : so I get

2004/12/03?

Try this:
SELECT DATE_ADD(date_column_name, INTERVAL 1 DAY) FROM table_name
Have a great day!
Ben :-)
Ben Gribaudo - Baltimore, MD - www.bengribaudo.com

"For God so loved the world, that he gave his only begotten Son, that
whosoever believeth in him should not perish, but have everlasting life."
John 3:16

"Alain Dhaene" <al**********@worldonline.be> wrote... Hi,

I retrieve a date from the mysql database.

e.g 2004/12/02

How is it possible to make this day with 1 day higher : so I get 2004/12/03?
Thx,

Alain

[Kelv]

Alain Dhaene wrote:

I retrieve a date from the mysql database.

e.g 2004/12/02

How is it possible to make this day with 1 day higher : so I get 2004/12/03?

If the dates are in datetime format you can manipulate them in all sorts
of ways. PHP is pretty flexible in date interpretation too. e.g

$today="2004/12/02";

$tomorrow = date("Y:m:d",strtotime("+1 day",strtotime($today)));

Hope that helps,

Kelv
--
LoHost
http://www.lohost.com