datediff question

oldnickj · #1 (**permalink**) 09-30-09, 11:23

I need to display the number of dayes left between today and July 27 2013.

I think I want to use DATEDIFF but not sure how to format it!

Nick

r937 · #2 (**permalink**) 09-30-09, 14:45

what have you tried so far, and what results did you get?

mnirwan · #3 (**permalink**) 09-30-09, 23:15

paramananda · #4 (**permalink**) 10-01-09, 02:09

Please use the below query:
SELECT DATEDIFF(day, pubdate, getdate()) AS no_of_days
FROM titles

r937 · #5 (**permalink**) 10-01-09, 07:12

Quote:

Originally Posted by paramananda

Please use the below query:
SELECT DATEDIFF(day, pubdate, getdate()) AS no_of_days
FROM titles

sorry, this will fail in mysql