Nov 18, 2025 · Reference for the CAST and CONVERT Transact-SQL functions. These functions convert expressions from one data type to another.

Example Convert an expression from one data type to another (varchar): SELECT CONVERT(varchar, '2017-08-25', 101); Try it Yourself » Previous SQL Server Functions Next

Nov 18, 2025 · Conversion functions support data type casting and conversion in the SQL Server Database Engine.

May 28, 2024 · In this article, we look at how to use the SQL CONVERT function to convert between data types such as date, integers, strings, and more.

May 2, 2026 · Learn how to use SQL CONVERT for different SQL date format options and achieve the desired date representation.

Mar 14, 2019 · This tutorial shows you how to use the SQL Server CONVERT() function to convert a value of one type to another.

SQL Server CONVERT () function converts an expression of one data type to another data type. The CONVERT () function is similar to the CAST () function except for the style parameter. The …

This SQL Server tutorial explains how to use the CONVERT function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the CONVERT function converts an …

Nov 11, 2023 · CONVERT Function in SQL Server The CONVERT () function changes the datatype of the given value or expression to a different datatype. For example, this function can convert the …

Jan 12, 2021 · The following table contains a list of the date formats that you can provide to the CONVERT() function when you convert a date/time value to a string. These formats are provided as …