List:General Discussion« Previous MessageNext Message »
From:Steven Staples Date:August 27 2010 5:43pm
Subject:RE: dynamic alias?
View as plain text  
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_Bloomquist@stripped]
> Sent: August 27, 2010 12:17 PM
> To: mysql@stripped
> 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=1
> 
> 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

Thread
dynamic alias?Eric Bloomquist27 Aug
  • Re: dynamic alias?Peter Brawley27 Aug
    • RE: dynamic alias?Eric Bloomquist27 Aug
      • Re: dynamic alias?Michael Dykman27 Aug
  • RE: dynamic alias?Steven Staples27 Aug