How do i convert the following result value to a whole number? meaning i dont want any values after the decimal point
the script below is used to create the results, but i guess i got to convert it somehow?
sum((datediff(day,DATEADD(dd, -DAY(data_as_at)+1, data_as_at), data_as_at)+1)*fte)
There is a dedicated function for that: FLOOR()
FLOOR() ad CEILING() are built-in ANSI/ISO Standard functions. They are covered in any intro SQL class.
--CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing: Analytics and OLAP in SQL / Data and Databases: Concepts in Practice Data / Measurements and Standards in SQL SQL for Smarties / SQL Programming Style / SQL Puzzles and Answers / Thinking in Sets / Trees and Hierarchies in SQL