Get joining year, joining month and joining date from
tblDNFRec table.
select SUBSTRING (convert(varchar,joining_date,103),7,4) as Year,
SUBSTRING (convert(varchar,joining_date,100),1,3) as Month,
SUBSTRING (convert(varchar,joining_date,100),5,2) as Date
from tblDNFRec
Thanks
Amatya