How to Find the Start and End Dates for the Current Week (and more)
Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)
2022-07-13
33,806 reads
Datetime Functions
Implementing Date Calculations in SQL
This article explains a way to use labels (last year, YTD, etc.) for report parameters.
2020-03-05
6,856 reads
2017-10-12
862 reads
2013-01-03
2,352 reads
Blogs
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
SQL Server 2025 CU1 Fixes the Docker Desktop AVX Issue on macOS
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
Forums
Unlock the Best Excel Tricks for 2026 Financial Reporting
Discover how to simplify, automate, and enhance your financial reporting with Excel in 2026....
25 Years of SQL Server Central
Comments posted to this topic are about the item 25 Years of SQL Server...
The Decoded Value
Comments posted to this topic are about the item The Decoded Value
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers