아이디어... >>>>SELECT   7 / 3 AS Expr1, 7 - 7 / 3 * 3
-------------------------------
SELECT   saname,
  DATEDIFF(dd, hiredate,GETDATE()) / 365 as 년,
 /* DATEDIFF(dd, hiredate,GETDATE()) - DATEDIFF(dd, hiredate, GETDATE()) / 365 * 365 , */
  (DATEDIFF(dd, hiredate,GETDATE()) - DATEDIFF(dd, hiredate, GETDATE()) / 365 * 365)/30 as 월,
 DATEDIFF(dd, hiredate,GETDATE()) - DATEDIFF(dd, hiredate, GETDATE()) / 365 * 365 -
  ( (DATEDIFF(dd, hiredate,GETDATE()) - DATEDIFF(dd, hiredate, GETDATE()) / 365 * 365)/30)*30 as 일
 
FROM      sawon
이 게시물을..