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, 1807🔥, 0💬
Popular Posts:
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...