Tutorialsteacher

Follow Us

Articles
  • C#
  • C# OOP
  • ASP.NET Core
  • ASP.NET MVC
  • LINQ
  • Inversion of Control (IoC)
  • Web API
  • JavaScript
  • TypeScript
  • jQuery
  • Angular 11
  • Node.js
  • D3.js
  • Sass
  • Python
  • Go lang
  • HTTPS (SSL)
  • Regex
  • SQL
  • SQL Server
  • PostgreSQL
  • MongoDB
  • SQL Server - Get Started
  • Install SQL Server
  • SQL Server Management Studio
  • SQL Server - Windows Authentication
  • SQL Server - Authentication
  • SQL Server - Create New User
  • SQL Server - GRANT/REVOKE Permissions to User
  • SQL Server - Data Types
  • SQL Server - Naming Conventions
  • SQL Server - CREATE Database
  • SQL Server - CREATE Table
  • Add Columns
  • Identity Column
  • Rename Column, Table
  • Drop Columns
  • SQL Server - Schema
  • SQL Server - Tables Relations
  • SQL Server - Primary Keys
  • Modify/Delete Primary Keys
  • SQL Server - Foreign Keys
  • Modify/Delete Foreign Keys
  • SQL Server - Check Constraints
  • SQL Server - Unique Constraints
  • SQL Server - Views
  • Modify/Delete Views
  • SQL Server - Functions
  • SQL Server - Stored Procedures
  • Stored Procedure Parameters
  • SQL Server - Indexes
  • Non-clustered Indexes
  • Modify/Delete Indexes
  • SQL Server - Triggers
  • DDL Triggers
  • LOGON Triggers
  • Enable/Disable Triggers
  • Modify/Delete Triggers
  • SQL Server - Sequence
  • SQL Server - Synonyms
  • SQL Server - IF ELSE Statement
  • SQL Server - Loops
  • SQL Server - Insert Data
  • SQL Server - Update Data
  • SQL Server - Delete Data
  • SQL Server - Select Query
  • WHERE Clause
  • GROUP BY Clause
  • HAVING Clause
  • ORDER BY Clause
  • SQL Server - Inner Join
  • Left Join
  • Right Join
  • Full Join
  • Self Join
  • Dynamic SQL
  • Built-in Functions
Entity Framework Extensions - Boost EF Core 9
  Bulk Insert
  Bulk Delete
  Bulk Update
  Bulk Merge

SQL Server CONVERT() Function: Convert DataType

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 CONVERT() is specific to SQL Server whereas CAST() is a part of ANSI SQL functions, which is available in many other databases.

It is recommended to use the TRY_CONVERT() function over the CONVERT() function to minimize errors.

CONVERT(data_type, expression[, style ])

Parameters

data_type: The target data type to which you want to convert the specified expression. It includes xml, bigint, and sql_variant.

expression: Any valid expression for which you want to convert the data type.

style: This is an optional integer that specifies how the CONVERT() function will translate the given expression. See the complete list of styles for data type conversion.

Return Value

Returns the expression converted to the target data type.

Example 1:

In the following example, the CONVERT() function converts from decimal to integer.

Example: CONVERT()
SELECT CONVERT(int, 22.56) AS Result;

Example 2:

In this example, CONVERT() function is used to convert a date passed as string with different styles. As seen in the result below, the style parameter has no effect on date passed as static string. Date is returned in the same format for both styles.

Example: CONVERT()
SELECT CONVERT(nvarchar(30), '11/23/2022 10:20:45', 110) AS dateUS,
    CONVERT(nvarchar(30), '11/23/2022 10:20:45', 113) AS dateEuro;

In the below example, current date is passed as the input date and date styles 110 (UD date format), style 112 (ISO standard) and 113 (Europe date format) is applied.

Note: Here you can see the different date formats when a date type is passed.

Example: CONVERT()
SELECT CONVERT (nvarchar(30), GETDATE(), 110) AS USdate,
    CONVERT(nvarchar(30), GETDATE(), 112) AS ISODate, 
    CONVERT(nvarchar(30), GETDATE(), 113) AS Eurodate;

Learn more about datetime styles.

Example 4

The following converts float to varchar type.

Example: CONVERT()
SELECT CONVERT (VARCHAR (10), 234.789)
TUTORIALSTEACHER.COM

TutorialsTeacher.com is your authoritative source for comprehensive technologies tutorials, tailored to guide you through mastering various web and other technologies through a step-by-step approach.

Our content helps you to learn technologies easily and quickly for learners of all levels. By accessing this platform, you acknowledge that you have reviewed and consented to abide by our Terms of Use and Privacy Policy, designed to safeguard your experience and privacy rights.

[email protected]

ABOUT USTERMS OF USEPRIVACY POLICY
copywrite-symbol

2024 TutorialsTeacher.com. (v 1.2) All Rights Reserved.