select
	to_number(
		substr(
			min(to_char(CREATED, 'yyyymmddhh24miss') || FOO)),
			15, 400
		)
	)
from table
where ...