0
How to write SQL query for Tenure from Table name (year-month-days)
for example : Josh joined on 02-Jul-15 .
3 Réponses
0
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
0
shall I use above query . Plz help
0
yeah...u should try it