Untitled

CREATE OR REPLACE FUNCTION public.random_date(start_date date, end_date date)
 RETURNS date
 LANGUAGE plpgsql
AS $function$
BEGIN
    RETURN start_date + (random() * (end_date - start_date))::INTEGER;
END;
$function$