Alex Dubitskiy

Difference between two dates in weeks

Returns difference between two dates in weeks, takes into account @@DATEFIRST setting

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

2008-05-28 (first published: 2008-04-11)

1,289 reads

A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...

Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...

Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

Comments posted to this topic are about the item Your Value from a Conference

Comments posted to this topic are about the item UNISTR Basics

What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)

SELECT UNISTR('Hello 4E16754C') AS 'A Classic';