Maurício,A sintaxe do datediff é DATEDIFF ( datepart, startdate, enddate), conforme descrito no link: http://msdn.microsoft.com/en-us/library/ms174630(SQL.90).aspx