how to store current_date in user variable

Question

Why can't I write like this?

set @date = SELECT CURRENT_DATE;

and how do i store return value of CURRENT_DATE in user variable?

Answer 1

Try this way:

set @MYVAR = Current_date();
SELECT @MYVAR;