RE: [PHP] Creating Dynamic Expiration Date

Yeah, I thought of that. I was looking for an alternate solution...I thought doing it from the datebase side would be more convenient (for my purpose). __________John Monfort_________________ _+-----------------------------------+_ P E P I E D E S I G N S www.pepiedesigns.com "The world is waiting, are you ready?" -+___________________________________+- On Tue, 6 Nov 2001, Martin Towell wrote: > Here's a thought - what about using PHP to generate the date :) > > -----Original Message----- > From: David Robley [mailto:huntsman@www.nisu.flinders.edu.au] > Sent: Tuesday, November 06, 2001 3:34 PM > To: John Monfort; php-general@lists.php.net > Subject: Re: [PHP] Creating Dynamic Expiration Date > > > On Tue, 6 Nov 2001 14:19, John Monfort wrote: > > Hello everyone, > > > > I'm developing a database which holds a START and EXPIRATION date. > > I would like to have MySQL generate the expiration date automatically > > and was wondering if that could be done. > > > > I'm using the MySQL NOW() to add today's date as the START date. > > The expiration date is one year from the start date. I read about the > > mysql DATE_ADD function, in which can be used as > > > > DATE_ADD("2001-11-05 13:00:00", INTERVAL 2 MONTHS) > > > > Is there a way to use it as DATE_ADD( NOW(), INTERVAL 1 YEAR), to > > automatically add one year to today's date. > > > > I tried the above, but it did not work. The start and expiration date > > still come out as the current date( the result of NOW() ). > > > > btw, both START and EXPIRATION are of the data type TIMESTAMP (8). > > > > Please help. > > > > How do I (dynamically) add one year to the current date? > > > > i.e. add_date(CURDATE(), INTERVAL 1 YEAR) > > > > Haven't time to research it just now, but date_to_days in MySQL rings a > bell. May be worth a look. > > -- > David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc > CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA > > Windows: From the people who brought you EDLIN! > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >