Thread: Date subtraction
View Single Post
  #2 (permalink)  
Old 2006-03-17, 09:35 AM
barand barand is offline
Member
  
Join Date: May 2003
Posts: 47
barand
Default
Something like

Code:
SELECT name, (TO_DAYS(CURDATE()) - TO_DAYS(start_date))/365 AS service_years FROM s_emp
ORDER BY service_years DESC
__________________
Barand
Reply With Quote