0

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

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

22nd Oct 2017, 10:23 AM
Joseph Reddy Kambham
3 Respostas
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
22nd Oct 2017, 12:28 PM
Joseph Reddy Kambham
0
shall I use above query . Plz help
22nd Oct 2017, 12:29 PM
Joseph Reddy Kambham
0
yeah...u should try it
22nd Oct 2017, 12:36 PM
Ranjit Mane
Ranjit Mane - avatar