Index: lams_tool_lamc/conf/hibernate/mappings/org/lamsfoundation/lams/tool/mc/McContent.hbm.xml
===================================================================
diff -u -ra63b5c3716c15dee472664a4648062cfc5872fc3 -r127c05cdcc1e19906d3f978d5d308b4e0218ec13
--- lams_tool_lamc/conf/hibernate/mappings/org/lamsfoundation/lams/tool/mc/McContent.hbm.xml	(.../McContent.hbm.xml)	(revision a63b5c3716c15dee472664a4648062cfc5872fc3)
+++ lams_tool_lamc/conf/hibernate/mappings/org/lamsfoundation/lams/tool/mc/McContent.hbm.xml	(.../McContent.hbm.xml)	(revision 127c05cdcc1e19906d3f978d5d308b4e0218ec13)
@@ -62,10 +62,10 @@
 
     <property
         name="creationDate"
-        type="java.lang.String"
+        type="java.util.Date"
         access="property"        
         column="creation_date"
-        length="10"
+        length="20"
     />
 
 
Index: lams_tool_lamc/db/model/lams_tool_mc.clay
===================================================================
diff -u -rf80f8ca251173376b790a2d05914a57cc1acb430 -r127c05cdcc1e19906d3f978d5d308b4e0218ec13
--- lams_tool_lamc/db/model/lams_tool_mc.clay	(.../lams_tool_mc.clay)	(revision f80f8ca251173376b790a2d05914a57cc1acb430)
+++ lams_tool_lamc/db/model/lams_tool_mc.clay	(.../lams_tool_mc.clay)	(revision 127c05cdcc1e19906d3f978d5d308b4e0218ec13)
@@ -49,11 +49,10 @@
 <variant type-name-pattern="TEXT"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="100" decimal-digits="0" default-value="" mandatory="false" name="creation_date" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="creation_date" remarks="">
 <column-description></column-description>
-<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
-<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
-<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
+<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="DATETIME" selected-variant-pattern="DATETIME">
+<variant type-name-pattern="DATETIME"/>
 </data-type>
 </column>
 <column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="update_date" remarks="">
Index: lams_tool_lamc/db/sql/create_lams_tool_mc.sql
===================================================================
diff -u -rf80f8ca251173376b790a2d05914a57cc1acb430 -r127c05cdcc1e19906d3f978d5d308b4e0218ec13
--- lams_tool_lamc/db/sql/create_lams_tool_mc.sql	(.../create_lams_tool_mc.sql)	(revision f80f8ca251173376b790a2d05914a57cc1acb430)
+++ lams_tool_lamc/db/sql/create_lams_tool_mc.sql	(.../create_lams_tool_mc.sql)	(revision 127c05cdcc1e19906d3f978d5d308b4e0218ec13)
@@ -3,7 +3,7 @@
      , content_id BIGINT(20) NOT NULL
      , title TEXT NOT NULL
      , instructions TEXT NOT NULL
-     , creation_date VARCHAR(100)
+     , creation_date DATETIME
      , update_date DATETIME
      , questions_sequenced TINYINT(1) NOT NULL DEFAULT 0
      , username_visible TINYINT(1) NOT NULL DEFAULT 0
@@ -113,7 +113,6 @@
                   REFERENCES lams.tl_lamc11_content (uid)
 )TYPE=InnoDB;
 
-
 INSERT INTO lams.tl_lamc11_content(uid, content_id , title , instructions , creation_date , questions_sequenced , username_visible , created_by , monitoring_report_title , report_title , run_offline , define_later, synch_in_monitor, offline_instructions, online_instructions, end_learning_message, content_in_use, retries, show_feedback, show_report) VALUES (1, ${default_content_id} ,'Mc Title','Mc Instructions', NOW(), 0, 0,1,'Monitoring Report','Report', 0, 0, 0,'offline instructions','online instructions','Finished Activity...', 0, 0, 0, 0);
 
 INSERT INTO lams.tl_lamc11_que_content  (uid,question, weight, disabled, display_order,  mc_content_id) VALUES (1, 'a sample question', 0, 1, 1,	1);
Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/pojos/McContent.java
===================================================================
diff -u -ree790a7f5518345f34674ab6d0293de0edbd6778 -r127c05cdcc1e19906d3f978d5d308b4e0218ec13
--- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/pojos/McContent.java	(.../McContent.java)	(revision ee790a7f5518345f34674ab6d0293de0edbd6778)
+++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/pojos/McContent.java	(.../McContent.java)	(revision 127c05cdcc1e19906d3f978d5d308b4e0218ec13)
@@ -65,7 +65,7 @@
     private boolean runOffline;
 
     /** nullable persistent field */
-    private String creationDate;
+    private Date creationDate;
 
     /** nullable persistent field */
     private Date updateDate;
@@ -123,7 +123,7 @@
     private Set mcAttachments;
 
     /** full constructor */
-    public McContent(Long mcContentId, String title, String instructions, boolean defineLater, boolean runOffline, String creationDate, 
+    public McContent(Long mcContentId, String title, String instructions, boolean defineLater, boolean runOffline, Date creationDate, 
     		Date updateDate, boolean questionsSequenced, boolean usernameVisible, String reportTitle, String monitoringReportTitle, 
 			long createdBy, boolean synchInMonitor, boolean contentInUse, String offlineInstructions, String onlineInstructions, 
 			String endLearningMessage, Integer passMark, boolean showReport, boolean showFeedback, boolean retries, Set mcQueContents, Set mcSessions, 
@@ -308,14 +308,6 @@
         this.runOffline = runOffline;
     }
 
-    public String getCreationDate() {
-        return this.creationDate;
-    }
-
-    public void setCreationDate(String creationDate) {
-        this.creationDate = creationDate;
-    }
-
     public Date getUpdateDate() {
         return this.updateDate;
     }
@@ -485,4 +477,16 @@
 	public void setMcAttachments(Set mcAttachments) {
 		this.mcAttachments = mcAttachments;
 	}
+	/**
+	 * @return Returns the creationDate.
+	 */
+	public Date getCreationDate() {
+		return creationDate;
+	}
+	/**
+	 * @param creationDate The creationDate to set.
+	 */
+	public void setCreationDate(Date creationDate) {
+		this.creationDate = creationDate;
+	}
 }