[AccessD] OT: SQL SERVER DATEDIFF - DECIMAL PRECISION

Stuart McLachlan stuart at lexacorp.com.pg
Wed May 26 06:01:56 CDT 2004 

On 26 May 2004 at 20:03, Stuart McLachlan wrote:
 
> Avg(CAST(DATEDIFF(day, StartDate, ClosedDate),Float)) AS TurnDays
> 

Make that 

Avg(CAST(DATEDIFF(day, StartDate, ClosedDate) AS Float)) AS TurnDays 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.

More information about the AccessD mailing list