drop function if exists showdate
//
create function showdate() returns varchar(20)
begin

   declare l_date date;
   
   set l_date  =  CURDATE();  

   return l_date;
   
end
//