1 2 3 4 5 6 7 8 9 10 11
| IF DATEDIFF(var_thisdate, now())> 31 OR FETCH_STATUS<> 0 THEN
SELECT var_date_dep= ADDDATE(now(), - DATEPART( weekday, now()) + 8);
SELECT var_date_dep= DATE_FORMAT (var_date_dep, '%e')
+ '/' + DATE_FORMAT (var_date_dep, '%c')
+'/' + DATE_FORMAT (var_date_dep, '%Y');
SELECT var_date_dep;
ELSE
SELECT var_date_dep= COALESCE( var_thisdate, DATE_FORMAT (ADDDATE (now(), -DATEPART (weekday, now())+8), '%e')
+ '/' + DATE_FORMAT (ADDDATE (now(), -DATEPART (weekday, now())+8), '%c')
+ '/' + DATE_FORMAT (ADDDATE (now(), -DATEPART (weekday, now())+8), '%Y');
END IF; |
Partager