How to write SQL query for Tenure from Table name (year-month-days)

Question

for example : Josh joined on 02-Jul-15 .

Answer 1

I think

select*From table name where name = 'Josh'

Select FIRST_NAME, to_char(joining_date,'YYYY') JoinYear , to_char(joining_date,'Mon'), to_char(joining_date,'dd') from EMPLOYEE

Answer 2

shall I use above query . Plz help

Answer 3

yeah...u should try it