>>So my problem is : (I want to get the difference in number of days when using the SPT cursor but the modification I want to do is on the cursor and not the expression used.)
>>Is there a way to change the datatype of a field in the cursor?
>>Is there any other simple way to tackle this problem?
>>
>>I can put some code before/after the creation of the cursor to solve this problem but I don't want to change the code where the comparision is used.
>>
>
>Check out the DatePart() function in SQL Books Online.

I can get the format as I want but only in a form of String but not as a date datatype.