Date in variable - mysql

Question

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

why store as var-char? If you select a date-type field out from mysql, it'll be a string yyyy-mm-dd in pretty much all clients. — Marc B
– Marc B, Commented Sep 12, 2013 at 18:51

jaczes · Accepted Answer · 2013-09-12 18:47:13Z

5

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) ;

edited Sep 12, 2013 at 18:47

answered Sep 12, 2013 at 18:41

jaczes

1,4042 gold badges9 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Bushwacka Over a year ago

Thank you for your comment it is helpful, but the result of @yesterday is (BLOB). Is it correct?

Reya276 Over a year ago

How can I use a variable within the Where clause?

jaczes Over a year ago

@Reya276 first you need to SET it (as @today) , and then WHERE YOUR_DATE=@TODAY

Collectives™ on Stack Overflow

Date in variable - mysql

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related