DATE_ADD(NOW(), INTERVAL 1 DAY) will give you tomorrow... Not sure if that is what you're looking for or not...
Steven Staples > -----Original Message----- > From: Eric Bloomquist [mailto:eric_bloomqu...@cooley-dickinson.org] > Sent: August 27, 2010 12:17 PM > To: mysql@lists.mysql.com > Subject: dynamic alias? > > Hi all, > > I'm wondering if it's possible to have a dynamic alias in MySQL. The > result I'm looking for is essentially: > > +-----------------+---------------------------+--------------------+ > | Provider Name | Facility Name | Appts on 8/28/2010 | <== > +-----------------+---------------------------+--------------------+ > | Mildred Ratched | Oregon State Hospital | 12 | > | Henry Jekyll | London Internal Medicine | 3 | > | ... | | | > > Where "Appts on 8/28/2010" instead includes whatever tomorrow's date is > when the query is run. > > Is it possible to do something like this in a MySQL query? > > Thanks, > Eric > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=sstap...@mnsi.net > > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 9.0.851 / Virus Database: 271.1.1/3089 - Release Date: 08/27/10 > 02:34:00 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
