SELECT TO_DATE(SCORE_DATE, 'ddMONyyyy') score_date from alm_leads_contact_history 
---------
SCORE_DATE

2/13/2006
2/13/2006
2/13/2006

CREATE TABLE alm_leads_history nologging as
	   SELECT 
	   		   BATCH_ID, LEAD_ID, INDIVIDUAL_ID, 
			   FIRST_NAME, LAST_NAME, CITY, 
			   STATE, COUNTRY_ID, WORK_PHONE_NO, 
			   JOB_ROLE_FUNCTION_GIVEN, TITLE_GIVEN, STANDARD_TITLE, 
			   NEW_STANDARD_TITLE, TIER3_AUDIENCE, FILTER_FLG, 
			   COMPANY_GIVEN, DUNS_NUMBER, MU_ATS_INDUSTRY, 
			   MU_EMPLOYEES_HERE, IND_LAST_ACTIVITY, LAST_ACTIVITY, 
			   IND_TENURE_IN_MONTHS, OMO_SCHEDULE_CODE, OMO_SCHEDULE_NAME, 
			   OMO_CAMPAIGN_NAME, OMO_PROGRAM_NAME, EST_PROB, 
			   MODEL_DECILE_SCORE, SEND_TO_OTS, DISPOSITION, 
			   NOTES, ACTIVITY_DATE,  TO_DATE(SCORE_DATE, 'ddMONyyyy') score_date,
			   ASSIGNED_SALES_CHNL 

		FROM DM_METRICS.alm_leads_contact_history
		;