Getting the Date for the Previous Saturday with T-SQL

SQL

Example of how to get the date for the previous Saturday for the current date using T-SQL.

/*SYNTAX*/
DATEADD(DAY, DATEDIFF(DAY, 5, GETDATE()) / 7 * 7, 5)

/*EXAMPLE*/

SELECT 
	ORDER_NO,
	PRODUCT_ID
FROM
	ORDERS
WHERE
	ORDER_DATE = DATEADD(DAY, DATEDIFF(DAY, 5, GETDATE()) / 7 * 7, 5)
Greg He
T-SQL
Did you find this snippet useful?

Sign up for free to to add this to your code library

Getting the Last Record Using Rank Function - T-SQL Example
SQL

T-SQL

43
Remove Leading Zeros from a Field with T-SQL
SQL

T-SQL | Data Cleaning

10
SQL generate_series, dayofweek(DOW), weekday, functions
SQL

7
left join LATERAL
SQL

7
median
SQL

7
SQL RANK
SQL

6
EXISTS
SQL

6
SQL window function II: percent growth
SQL

6
SQL creating a view
SQL

6
SQL window function
SQL

5