anchor.diff:  	if (dateAfter != null && !dateAfter.isEmpty()) {
   		%>contains data recorded after <%= dateAfter%>', <%
   		//dateAfter = "AND a.date_created >= TO_DATE("+dateAfter+",'mm/dd/yyyy')";
  -	   queryAudio = queryAudio + " AND a.date_created >= TO_DATE('"+dateAfter+"','dd/mm/yyyy')";
  -	   queryImage = queryImage + " AND i.date_created >= TO_DATE('"+dateAfter+"','dd/mm/yyyy')";
  -	   queryScalar = queryScalar + " AND s.date_created >= TO_DATE('"+dateAfter+"','dd/mm/yyyy')";
  +	   queryAudio = queryAudio + " AND a.date_created >= TO_DATE('"+dateAfter+"','dd/mm/yyyy HH24:MI:SS')";
  +	   queryImage = queryImage + " AND i.date_created >= TO_DATE('"+dateAfter+"','dd/mm/yyyy HH24:MI:SS')";
  +	   queryScalar = queryScalar + " AND s.date_created >= TO_DATE('"+dateAfter+"','dd/mm/yyyy HH24:MI:SS')";
   
   	   //querySensor = querySensor + " AND sen.date_created >= TO_DATE('"+dateAfter+"','dd/mm/yyyy')";
   
  
positive.code: 	if (dateBefore != null && !dateBefore.isEmpty()) {
  		%>contains data recorded before <%= dateBefore%>', <%
  		//dateBefore = "AND a.date_created <= TO_DATE("+dateBefore+",'mm/dd/yyyy')";
  	   queryAudio = queryAudio + " AND a.date_created <= TO_DATE('"+dateBefore+"','dd/mm/yyyy')";
  	   queryImage = queryImage + " AND i.date_created <= TO_DATE('"+dateBefore+"','dd/mm/yyyy')";
  	   queryScalar = queryScalar + " AND s.date_created <= TO_DATE('"+dateBefore+"','dd/mm/yyyy')";
  
  	   //querySensor = querySensor + " AND sen.date_created <= TO_DATE('"+dateBefore+"','dd/mm/yyyy')";
  
  
negative.code: //DONE on my end. Need to edit html side:  dd/mm/yyyy. 
  //DONE: keyword should be exact match.
  //TODO: Ask TA if the user needs to be able to search by hour,min,second. If so, implement that.
  //DONE?: Apparently Sensor type must have a time period.
  //DONE: Select blob columns.
  //DONE: "If the keyword matches the sensor description, show all data from this sensor. 
  //If not (in case of audio files and images), try if it matches the image or audio description.
  //and show those records which match." I can't simply search sensor because sensor doesn't have a date created. Therefore, if I use a "or" statement there, time doesn't matter.
  //DONE in a sense. Need to handle it website side as well: Error catching. A common offender will be if they input date off format.
  //TODO: Testing Website side.
          Boolean debug = Boolean.TRUE;
  