[thelist] SQL Query Question

[Tab Alleman]

Jay Blanchard wrote:
> 2. Method Two - DATE_ADD to the StartDate, if today is = or > that
> date, tech support is over. To calc number of days
> SELECT((DATE_ADD(StartDate, INTERVAL 90 DAYS))-CURRENT_DATE()) AS
> DaysLeft FROM table 

Note that, along with this method, you could add some kind of
ContractLength column, in case you ever want to give certain customers
something other than 90 days.