>If I have this:
>
>
>SELECT SUM(DATEDIFF(d,Holiday.Start,Holiday.End))
>
>
>...I can obtain 365.
>
>Now, if I change the type to s, to obtain this same amount in seconds:
>
>
>SELECT SUM(DATEDIFF(s,Holiday.Start,Holiday.End))
>
>
>...I obtain 23533200.
>
>However, If I do 23533200/84600, I do not obtain 365 days but only 272.38.
>
>What am I missing?
Do you always have Start and end as 12 AM ?
If it's not broken, fix it until it is.
My Blog