SELECT CAST(CURRENT_DATE() AS CHAR(50)) INTO @today; SELECT CAST(DATE_ADD(CURRENT_DATE, INTERVAL -1 DAY) AS DATE) INTO @yesterday; SELECT @today, @yesterday