sql - Find last sunday

Question

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

How will you find last sunday of a month in sql 2000?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

308 views

1 Answer

深蓝 · Answer 1 · 2021-10-17T02:58:03+0000

SELECT
 DATEADD(day,DATEDIFF(day,'19000107',DATEADD(month,DATEDIFF(MONTH,0,GETDATE() /*YourValuehere*/),30))/7*7,'19000107')

Edit: A correct, final, working answer from my colleague.