SQL計算周起迄日
跳至導覽
跳至搜尋
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>