Link to home
Start Free TrialLog in
Avatar of isames
isames

asked on

SQL Query

I wrote the following query, which gives me what I need for a while.

Select
Datediff(d, '2015-01-01', 'name of date column')
from table

How can I get 2015-01-01 to change to 2016-01-01 automatically, so I don't have to remember to change it?

Thanks!!!
SOLUTION
Avatar of Russ Suter
Russ Suter

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial