æè·¯ï¼
1ãé¦å
ä½ è¦ç¥éåªå¹´çæ¥èæ¯åªå¤©
2ãå
¶æ¬¡è¿è¦ç¥éç°å¨æ¯åªå¹´ï¼ç¶åå©ç¨å½æ°ãdatediffãæ±åºè·ç¦»æè¿çæ¥è天æ°å·®å¼
解å³æ¹æ³ï¼
ä¸é¢æ¯å年以å
çæ¥èæ¥æ
2016å¹´2æ8å·ï¼2017å¹´1æ28å·ï¼2018å¹´2æ16å·ï¼2019å¹´2æ5å·ï¼2020å¹´1æ25å·ï¼2021å¹´2æ12å·ï¼2022å¹´2æ1å·ï¼2023å¹´1æ22å·ï¼2024å¹´2æ10å·ï¼2025å¹´1æ29å·
ç¶åå¤çSQLè¯å¥æ¯ï¼
select
top 1
DATEPART(yyyy,chunjie) æ¥è年份,
DATEDIFF(DD,GETDATE(),chunjie) è·ç¦»æ¥èå©ä½å¤©æ°
from
(
select '2016-2-8' chunjie union all
select '2017-1-28' union all
select '2018-2-16' union all
select '2019-2-5' union all
select '2020-1-25' union all
select '2021-2-12' union all
select '2022-2-1' union all
select '2023-1-22' union all
select '2024-2-10' union all
select '2025-1-29'
) a
where
DATEDIFF(DD,GETDATE(),chunjie)>=0
order by
DATEDIFF(DD,GETDATE(),chunjie)