> I have a DATE field that includes a date sometime within the past 30 > days. I'm trying to show the number of days until the expiration > date, which is 30 days in the future from the date in the field. I've > tried a bunch of permutations of something like this: > > select (30 - SUBDATE(CURDATE() - datefield)) as expiration_days > > All my permutations give me errors. Can someone set me straight? I'm > hoping to get an integer between 1 and 30 (30 day old records are > purged separately).
SELECT DATE_ADD(datefield, INTERVAL 30 DAY) from table; -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
