David Strack

Avoiding Unexpected Results with DATEDIFF in Year Comparisons

Learn how to avoid unexpected results when using the DATEDIFF function to find the difference between two dates in years.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2.22 (9)

You rated this post out of 5. Change rating

2018-04-09

1,708 reads

In the technologically driven world of 2024, more individuals are finding themselves drawn towards the...

I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...

We’ve been doing some events as part of the Redgate Roadshow, and at one...

CREATE TABLE #tempdblogin ( lastcheck nvarchar(100) ) EXEC sp_MSforeachdb 'USE ? insert into #tempdblogin...

I am considering implementing an Azure Postgres DB for use in a part of...

Every time the dev team runs their dacpac, they encounter an issue. "This deployment...