CODEWITHSUNDEEP
mysqlvariablesdatecasting
Bushwacka
Bushwacka

Reputation: 915

Date in variable - mysql

i would need to help how can i save into my variable @today from CURRENT_DATE() value on VARCHAR type as you can see in first SET row and in the second row in my variable @yesterday i would like to save the value in DATE type.

SET @today=CAST(CURRENT_DATE() AS VARCHAR(50)),
@yesterday=CAST(DATE_ADD(CURRENT_DATE, INTERVAL -1 DAY) AS DATE)

SELECT @today, @yesterday

Thanks for your help

Upvotes: 4

Views: 12247

Answers (1)

jaczes
jaczes

Reputation: 1394

That may help:

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

EDIT: Your version also works, but You can't cast into VARCHAR()

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

Upvotes: 5

Related Questions