Question

SQL的除法计算

SELECT (DATEDIFF(month ,CONVERT(varchar(100),hire_date,23), CONVERT(varchar(100), GETDATE(),23)) AS DiffDate) from View_1
他得到的结果是一个整数 我要让这个得到的整数除以12应该怎么写
在线等急
SELECT (DATEDIFF(month ,CONVERT(varchar(100),hire_date,23), CONVERT(varchar(100), GETDATE(),23)) AS DiffDate)/12 from View_1 这个是试过了报错

Answer 1

SELECT DATEDIFF(month ,CONVERT(varchar(100),hire_date,23), CONVERT(varchar(100), GETDATE(),23))/12 as DiffDate from View_1

AS ... 作为值的自定义列名,在语句中应当放在值之后

Answer 2

SELECT (DATEDIFF(month ,CONVERT(varchar(100),hire_date,23), CONVERT(varchar(100), GETDATE(),23)) AS DiffDate)/12 from View_1