Collections:
Performing Comparison on Date and Time Values in SQL Server
How To Perform Comparison on Date and Time Values in SQL Server Transact-SQL?
✍: FYIcenter.com
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.
⇒ Performing Comparison on Character Strings in SQL Server
⇐ Performing Comparison on Floating Point Numbers in SQL Server
⇑ Boolean Values and Logical Operations in SQL Server Transact-SQL
2017-01-21, 1709🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...