SQL CONVERT Function

SQL > SQL String Functions > CONVERT Function

The CONVERT function in MySQL and SQL Server converts data from one data type to another.

The syntax of the CONVERT function is as follows:

CONVERT (expression, [data type])

where [data type] is a valid data type in the RDBMS you are working with.

We use the following table for our example.

Table Student_Score

Column Name Data Type

StudentID integer

First_Name char(20)

Score float

This table contains the following rows:

Table Student_Score

StudentID First_Name Score

1 Jenny 85.2

2 Bob 92.5

3 Alice 90

4 James 120.1

The SQL statement,

SELECT First_Name, CONVERT(Score, Integer) Int_Score FROM Student_Score;

produces the following result set:

First_Name Int_Score

Jenny 85

Bob 92

Alice 90

James 120

In Oracle, the CONVERT function is used differently. It converts a string from one character set to another.

CONVERT (string, [new character set], [original character set])

Next: SQL CONCATENATE

This page was last updated on October 12, 2024.

AdBlock Detected!