Literal does not match format string error in oracle
Oracle doesn't understand the literal date format strings, as they are not in the same format that your client is configured for. You need to use the TO_DATE function to tell Oracle the format of the date string you are presenting it with, like so:

AND (ACTIVITY.ACTIVITY_START_DATE &gt;= TO_DATE('2014-02-05 00:00:00','YYYY-MM-DD HH24:MI:SS')) 
AND (ACTIVITY.ACTIVITY_START_DATE &lt; TO_DATE('2014-02-06 00:00:00','YYYY-MM-DD HH24:MI:SS')));


You could also represent your dates using ANSI syntax (seeing as they have no time component):

AND (ACTIVITY.ACTIVITY_START_DATE &gt;= DATE'2014-02-05') 
AND (ACTIVITY.ACTIVITY_START_DATE &lt; DATE'2014-02-06'));