Table of contentsImplicit data conversionExplicit Type Conversions with CAST AND CONVERTCASTCONVERTCONVERT DATETIME TYPESSummaryRelated SQL Conversion Function Posts Implicit data conversion Implicit conversions

Read More
SQL Data Conversions

The SQL LOWER function converts the input character data to a lower case. Description The LOWER function takes character expression as an

Read More
SQL LOWER Function (Transact SQL)

The SQL YEAR function evaluates the input date and returns the year part as an integer.Description The YEAR function works the same

Read More
SQL YEAR Function (Transact SQL)

The SQL CEILING function returns the smallest integer value greater than or equal to the input value. Description The CEILING function evaluates

Read More
SQL CEILING Function (Transact SQL)

When working with NULL, you’ll often find yourself wanting to replace these “missing” values, with something else. Just use ISNULL to do

Read More
Replace Missing Values in your Queries using ISNULL

The SQL UPPER function converts the input character expression to an upper case and returns it. Description The UPPER function reads the

Read More
SQL UPPER Function (Transact SQL)