awesome. thank you!
[Wed, Aug 25, 2004 at 06:27:38PM -0700] This one time, at band camp, David Perron said: > > Are you assuming that all months have 30 days? You can use the same syntax > with INTERVAL 1 MONTH > I would also format the date comparison to use the same precision that the > DATE_ADD function outputs. > > So, > > DATE_ADD(table.date, INTERVAL 1 MONTH) <= DATE_FORMAT(CURDATE(), '%Y-%m-%d') > > I might be off on the 1 MONTH part, but I think it's the right track. > > -----Original Message----- > From: Redmond Militante [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 25, 2004 6:03 PM > To: [EMAIL PROTECTED] > Subject: need help with a query > > hi > > i need advice on a query i'm trying to do. i'm trying to find entries with > that are about to expire. entries expire if their date of submission is > older than 60 days. i want to find all entries with a date of submission > greater than 30 days, or those that are going to expire within a month > > i'm using this as part of my query to find entries that are about to expire: > ' ... DATE_ADD($dbtable3.savedemployers2, INTERVAL 30 DAY) <=NOW()' > > am i doing this the right way? > > thanks > redmond > > -- > Redmond Militante > Software Engineer / Medill School of Journalism FreeBSD 5.2.1-RELEASE-p9 #0: > Thu Jul 1 14:36:26 CDT 2004 i386 8:00PM up 28 days, 3:36, 4 users, load > averages: 0.00, 0.29, 0.51 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- Redmond Militante Software Engineer / Medill School of Journalism FreeBSD 5.2.1-RELEASE-p9 #0: Thu Jul 1 14:36:26 CDT 2004 i386 11:00PM up 28 days, 6:36, 3 users, load averages: 0.22, 0.18, 0.30
pgpC8omL1KwJU.pgp
Description: PGP signature