例如，考慮 2023 年 4 月。今年的星期一日期是 3、10、17 和 24。現在我想獲取 4 月的日期 10 位置。
我的目標結果是：4 月 10 日 = 秒或 2
uj5u.com熱心網友回復：
選擇 (DAY('2023-04-10') - 1) / 7 1
uj5u.com熱心網友回復：
查看位置
WITH CTE_DATES
AS(
SELECT CAST(DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) -1, 0) AS DATE) AS [DATE] -- start previous month
UNION ALL
SELECT CAST(DATEADD(DD, 1, [DATE]) AS DATE)
FROM [CTE_DATES]
WHERE [DATE] < DATEADD(ms, -3, DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) 0, 0)) -- end previous month
)
SELECT
[date]
,DATENAME(WEEKDAY, [date]) AS 'Weekday'
,DATEPART(WEEKDAY, [date]) AS 'Day'
,ROW_NUMBER() OVER (ORDER BY [date] ASC) AS 'POSITION'
FROM [CTE_DATES]
WHERE DATEPART(WEEKDAY, [date]) IN (1)
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/366938.html
標籤：sql-server 查询语句
上一篇：如何在MsSQL中創建created_at和updated_at欄位？
下一篇：T-SQL，如何決議這個XML？