How do I change a date field to a numerica field?

Question

I have my ending date field and my beginning date field but need to show the difference as an integer.

Answer 1

0

Difference as an integer representing what? Days? DATEDIFF function is going to be useful here.

select datediff(dd, '1 jun 2010','30 jun 2010')

Check out the documentation on that link, and change the dd for another datepart to get other values

answered Jun 17 '11 at 12:17 PM

Kev Riley ♦♦
46.1k ● 38 ● 43 ● 69

spot on.Thats the function we need to use.

Jun 17 '11 at 12:26 PM aRookieBIdev

(comments are locked)