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, 1712🔥, 0💬
Popular Posts:
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...