Jump to content


Photo

Adding 30 days to now() in mysql


  • Please log in to reply
2 replies to this topic

#1 MikoMak

MikoMak
  • Members
  • PipPip
  • Member
  • 20 posts

Posted 21 March 2006 - 03:04 PM

Hi all,

I'd like to enter 2 dates into a table,

date today [I'm using now()] and
date 30 days from today

How do I go about adding 30 days to now() and inserting it into the table?

I'll be running a script daily to check if todays date matches the expiry date and deleting the row accordingly.

Thanx,
MikoMak.

#2 php_b34st

php_b34st
  • Members
  • PipPipPip
  • Advanced Member
  • 168 posts

Posted 21 March 2006 - 06:47 PM

You could use $date and $strtotime to get the date and then add 30 days to it like this:

<?php
//date today
$date = date("Y-m-d");

//put into string
$current_date = strtotime($date);

//add 30 days
$new_date = date("Y-M-D",$current_date+=2592000);

//display dates
echo 'Todays date is ' . $date . '<br />';

echo 'The date 30 days from now will be ' . $new_date;
?>

You can then put either the string or the date format into your db.

#3 MikoMak

MikoMak
  • Members
  • PipPip
  • Member
  • 20 posts

Posted 22 March 2006 - 09:14 AM

Thanx for that php_b34st,

works great.






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users