SQL > SQL String Functions > CONVERT Function

In MySQL and SQL Server, the CONVERT function is very similar to the CAST function in that they both change the value from one data type to another. In this scenario, 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.

Let's go through an example to see how the CONVERT function is used. Let's assume we have the following table:

Table Student_Score

Column NameData Type
StudentIDinteger
First_Namechar(20)
Scorefloat

and this table contains the following rows:

Table Student_Score

StudentIDFirst_NameScore
1Jenny85.2
2Bob92.5
3Alice90
4James120.1

Example

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

Result:

First_NameInt_Score
Jenny85
Bob92
Alice90
James120

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

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

Next: SQL CONCATENATE




Copyright © 2014   1keydata.com   All Rights Reserved.     Privacy Policy     About   Contact