Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select first_name "Numele", last_name "Prenumele", round(trunc(months_between(sysdate,hire_date))/12,1) "Anii de lucru" , hire_date "Data Angajarii", sysdate "Data actuala" from employees
- select trunc(sysdate-to_date('03_Jan-1997','dd-Mon-yyyy')) "Am trait atatea zile",to_char(to_date('03_Jan-1997','dd-Mon-yyyy'),'day') from dual
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement