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, 1884🔥, 0💬
Popular Posts:
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...