Get joining year, joining month and joining date from tblDNFRec table.

Amatya
Posted by Amatya under Sql Server category on | Points: 40 | Views : 461
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

Comments or Responses

Login to post response