Re: Creating Dynamic Expiration Date

On Tue, 6 Nov 2001 17:45, Jack Dempsey wrote: > ok, that's why: AFAIK you can't use functions like date_add in create > clauses because they're functions, and need to be used in things like > selects... What he said :-) I would think you could do this as you insert each record, anyway (or perhaps that's what the start of this thread was all about). > > -----Original Message----- > From: John Monfort [mailto:monfort@kahuna.sdsu.edu] > Sent: Tuesday, November 06, 2001 2:05 AM > To: David Robley > Cc: php-general@lists.php.net > Subject: Re: [PHP] Creating Dynamic Expiration Date > > > > > David, > > You're right, the way you used is fine. However, I was looking for > something different. > > I'm trying to use it in the following method: > > //my MySQL table definition > > CREATE TABLE members ( > ... > date_created timestamp(8) DEFAULT'NOW()', //This works!! > date_expired timestamp(8) DEFAULT 'DATE_ADD(NOW(), INTERVAL 1 YEAR)' > , ... > ); > > I hope this show my troubles. > > Come to think of it, MySQL does not allow TRIGGERS (as far as I know). > Is the above considered a trigger? > > --Is what I'm trying to do even possible? > > I basically want to set the result of DATE_ADD() as the > field's DEFAULT value. > > > __________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, David Robley wrote: > > 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) -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA You have two choices for dinner: Take it or Leave it.