Performing Comparison on Date and Time Values in SQL Server

Q

How To Perform Comparison on Date and Time Values in SQL Server Transact-SQL?

✍: FYIcenter.com

A

Comparison operations on date and time values can be performed in the same way as numeric values. The comparison rule is simple: a date and time value in the future has a greater value than a date and time value in the past. The tutorial exercise below shows you a good example:

-- Future date has a greater value
DECLARE @his_birth_date DATETIME, @her_birth_date DATETIME;
SET @his_birth_date = '1987-05-19'; 
SET @her_birth_date = '1988-07-07'; 
SELECT CASE WHEN @his_birth_date < @her_birth_date THEN 
      'He is older.' 
   ELSE 
      'She is older.' 
   END;
GO
He is older.

 

Boolean Values and Logical Operations in SQL Server Transact-SQL

⇒⇒SQL Server Transact-SQL Tutorials

2017-01-21, 271👍, 0💬