Created On: 11/24/2004 10:15:00 AM You may use DateDiff function in an SQL statement to get the number of date and/or time between two dates. You may calculate days between two different date. The return number of DateDiff function can be year, month, day, hour, minute, second ....
select datediff(day, pubDate, endDate) from news where newsID = 12 |
