>>>>Hi,
>>>>
>>>>I created a computed column in a table of SQL Server 2005. The column name is DaysOver. The formula in the Computed Column Specificaion is [Date1]-[Date2]. The type of the column is empty. Does this column always return an integer? Because I use it in the SQL select as following:
>>>>
>>>>
>>>>select * from MyTable where DaysOver > 10
>>>>
>>>>
>>>>And the returned query has the correct rows. But what if one of the DateTime columns (Date1 or Date2) is NULL? What will be returned?
>>>
>>>I hope you're using DATEDIFF function. The datediff function returns an integer. The type of derived column is determined by SQL Server itself and it may be tricky.
>>>
>>>You can also try adding CAST function if you want to ensure a specific type.
>>
>>As far as DATEDIFF, how would the syntax work? That is, if I want to replace the formula [Date1]-[Date2] with using DATEDIFF, what would the formula look like?
>>
>>Thank you.
>
>If you want to return difference in Days, then the formula is
>
>datediff(day, Date1, Date2).
>
It works. Thank you very much! Btw, I think John Baird would be proud of me since I just looked up the function DateDiff in the Books Online <g>
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham