I have some dates fields in table. These columns contain dates in the following format:

mmddyy

For example:

31/12/2010 00:00:00:0000

I need to import these values into a table which is set to varchar and numeric and formats dates like this:

monthName varchar
Year numeric(4,0)

currently I'm using

INSERT INTO [School].[dbo].[TeacherAttendenceDet] 
            ([TeacherCode], 
             [MonthName], 
             [Year]) 
(SELECT MAX(employeecode), 
        Datename(MONTH, dateofjoining) AS MONTH, 
        Datepart(YEAR, dateofjoining)  AS DATE 
 FROM   employeedet 
 GROUP  BY dateofjoining) 

but datename() gives result in date format.. I have to save it in varchar format

How can I do this? this is employeemast table:

EmployeeCode    numeric(5, 0)   
PayScaleCode    numeric(7, 0)   
DesignationCode varchar(50) 
CityCode    numeric(5, 0)   
EmployeeName    varchar(50) 
FatherName  varchar(50) 
BirthDate   varchar(50) 
DateOfJoining   varchar(50) 
Address varchar(150)    

this is TeacherAttendenceDet table

TeacherCode numeric(5, 0)   Unchecked
Year    numeric(4, 0)   Unchecked
MonthName   varchar(12) Unchecked

i have to insert in teacherattendencedet table the monthname and year from employeemast