>>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.
"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