alter table INTERNSHIP_CANDIDACY add column CANDIDACY_DATE timestamp NULL default NULL;

update INTERNSHIP_CANDIDACY set CANDIDACY_DATE='2008-11-12 00:00:00';