zxo102 wrote:

>Hi everyone,
> I need your help. I have a simple query against the table: test in
>SQL server
> select DATEDIFF(day,date1,getDate())/DATEDIFF(day,date1,date2) as
>r_ratio from test;
> where date1 and date2 are the two fields (datetime). Also date2 >
>getDate() > date1.
>
> This query returns 0 since all decimals are truncated. But I do need
>the decimal ratio. Anybody knows how to get it? Thanks.
>
>Ouyang
>
>