sminnee / silverstripe-framework

				user_error('formattedDatetimeClause(): unsupported format character %' . $match, E_USER_WARNING);

			}

		if (preg_match('/^now$/i', $date)) {

			$date = "NOW()";

		} else if (preg_match('/^\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}$/i', $date)) {

			$date = "'$date'";

		}

		if ($format == '%U') return "UNIX_TIMESTAMP($date)";

	public function datetimeIntervalClause($date, $interval) {

		$interval = preg_replace('/(year|month|day|hour|minute|second)s/i', '$1', $interval);

		if (preg_match('/^now$/i', $date)) {

			$date = "NOW()";

		} else if (preg_match('/^\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}$/i', $date)) {

			$date = "'$date'";

		}

		return "$date + INTERVAL $interval";

	}