Time & Date +24H, help!?

[jamesxg1]

Hiya peeps,

 

I have two rows titled `expiry_date` and `expiry_time` I need to find a way to add 24 hours onto the current time and then insert what date and time that would be. How would I go about this?

 

Many thanks,

 

James.

[bh]

Hi,

 

With DATE_ADD function its simple:

SELECT DATE_ADD(NOW(), INTERVAL 24 HOUR);

 

DATE_ADD: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-add

[aleX_hill]

If you wanted to get that time and date in PHP you can do:

$expiry = time() + (24 * 60 * 60);

which will give you the unix timestamp of the expiry time. You can then use date() to split the timestamp into a date and time in whichever format you want.

[jamesxg1]

If you wanted to get that time and date in PHP you can do:

$expiry = time() + (24 * 60 * 60);

which will give you the unix timestamp of the expiry time. You can then use date() to split the timestamp into a date and time in whichever format you want.

 

Thanks mate, worked a charm.

 

Many thanks,

 

James.