interval to int

Hi all, THis should be obvious but I can't find the answer: how do you convert an interval to an integer ... as in: select noofweeksvacation from vacation_table where yearsservice <= interval (today - startdate) year to year the column yearsservice is a smallint i keep getting an error when doing this ... thanks, marc ------------------------------------------------------------------------------ H. Marc Kneppers System Administrator knepperm@cuug.ab.ca PAMCO, A Divison of Enerflex marc@eeyore.pamco.com <a href="http://www.cuug.ab.ca:8001/~knepperm">Marc's temporary Home</a> ------------------------------------------------------------------------------ "My mom says I'm cool" - Milhouse "Kiss my Royal Canadian!!" "Power to the people! Stick it to the man!"