public static List<Appointment> findByDay(long uid, long day)
			throws SQLException {
		List<Appointment> aAppt = new ArrayList<Appointment>();

		// once
		aAppt.addAll(Appointment.findOnceByDaySpan(uid, day, day));

		// daily
		aAppt.addAll(Appointment.findDailyByDaySpan(uid, day, day));

		// weekly
		aAppt.addAll(Appointment.findWeeklyByDay(uid, day));

		// monthly
		aAppt.addAll(Appointment.findMonthlyByDaySpan(uid, day, day));

		return aAppt;
	}