SQL計算周起迄日

出自TSK WIKI
於 2019年12月28日 (六) 12:42 由 Stanleyliu​(留言 | 貢獻) 所做的修訂 (已建立頁面,內容為 "==BOXSIZE KEY入箱號大小== <sql> SELECT * FROM (SELECT DATEPART( wk, C_TIME) WEEK, CONVERT(VARCHAR,DATEADD(WEEK, DATEDIFF(WEEK,0, GETDATE()) - (DATEPART(WEEK, GE…")
(差異) ←上個修訂 | 最新修訂 (差異) | 下個修訂→ (差異)
跳至導覽 跳至搜尋

BOXSIZE KEY入箱號大小

<sql> SELECT * FROM (SELECT DATEPART( wk, C_TIME) WEEK, CONVERT(VARCHAR,DATEADD(WEEK, DATEDIFF(WEEK,0, GETDATE()) - (DATEPART(WEEK, GETDATE()) - DATEPART( wk, C_TIME)), 0),112) ST, CONVERT(VARCHAR,DATEADD(WEEK, DATEDIFF(WEEK,0, GETDATE()) - (DATEPART(WEEK, GETDATE()) - DATEPART( wk, C_TIME)), 4),112) ED, count(BTA002) AMOUNT FROM BOXSIZE GROUP BY DATEPART( wk, C_TIME) )X ORDER BY WEEK </sql>