[thelist] SQL Query Question
Tab Alleman
Tab.Alleman at MetroGuide.com
Wed Aug 13 14:35:54 CDT 2003
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.
More information about the thelist
mailing list