'creation of store procedure in aws redshift

While creating the store procedure to create the table in redshift, I am not able to create the table by concatenating with current date. could please help me anyone.

Here is my code :

create or replace procedure stud.studentlists()
as $$
declare get_date date;
begin
   execute 'CREATE TEMP TABLE stud.students_list_||"get_date" 
as
   select * from stud.students_list;
'
end
$$ LANGUAGE plpgsql;


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source