Status: Solved
Priority: Medium
Security: Public
Views: 706
Last Modified: 2012-12-21

tsql check if datediff is 2 days only btween enddate and getdate

i want to use the function datediff to match all record whe have difference btween the enddate end current date is 2

for example each record has a expirydate i want to gets all records where the subscription end after 2 days

AFIF JABADO

Asked: 2012-12-21

Advertise Here

1 Solution

LVL 13

Yagya ShreeCommented: 2012-12-21

Please use below query

Select getdate+2
Select enddate-2

LVL 42

Kyle AbrahamsSenior .Net DeveloperCommented: 2012-12-21

select * from subscriptions
where datediff(d, getdate(), subscription_date) > 2

LVL 1

AFIF JABADOAuthor Commented: 2012-12-21

i want only get if is equal to 2 !! for automatic renew the subscription
if the expiration end after 2 days i will send to the user a notification not > 2

LVL 42

Kyle AbrahamsSenior .Net DeveloperCommented: 2012-12-21

select * from subscriptions
where datediff(d, getdate(), expiry_date) = 2

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

tsql check if datediff is 2 days only btween enddate and getdate

Join & Write a Comment Already a member? Login.

Featured Post