day difference between today's date and a specified date in SQL
<p>How to find the day difference between today's date and a specified date in SQL. The specified date column(P.SubscrpEndDate__c) is in Date time format(12/1/2014 12:00 Am). I have used the below query but it do not works</p>

<pre><code>DATEDIFF(day,GETDATE(), P.SubscrpEndDate__c)  AS 'SubscriptionDueDate' 
</code></pre>