找這個月第二個星期三的日期
- Eddy
-
Topic Author
- Offline
- 管理員
-
Less
More
2006-05-15 16:06 #2437
來自 Eddy
知之者不如好之者，好之者不如樂之者
Eddy created the topic: 找這個月第二個星期三的日期
SET @First = CONCAT(EXTRACT(YEAR_MONTH FROM (DATE_ADD(CURRENT_DATE,INTERVAL 1 MONTH))),"01");
SELECT DATE_ADD(@First,INTERVAL (11 + (7 * (DAYOFWEEK(@First) > 4)) - DAYOFWEEK(@First)) DAY);
SELECT DATE_ADD(@First,INTERVAL (11 + (7 * (DAYOFWEEK(@First) > 4)) - DAYOFWEEK(@First)) DAY);
知之者不如好之者，好之者不如樂之者
Please 登入 to join the conversation.