diff --git a/lib/visit.js b/lib/visit.js
index <HASH>..<HASH> 100644
--- a/lib/visit.js
+++ b/lib/visit.js
@@ -189,5 +189,19 @@ exports.listVisitsForKouhi = function(conn, kouhiId, cb){
 	})
 };
 
+exports.listVisitsByDate = function(conn, at, cb){
+	var sql = "select * from visit where date(v_datetime) = date(?) " +
+		" order by visit_id ";
+	var args = [at];
+	conn.query(sql, args, function(err, result){
+		if( err ){
+			cb(err);
+			return;
+		}
+		result.forEach(util.deleteUnusedVisitColumn);
+		cb(undefined, result);
+	})
+}
+
added listVisitsByDate