Conversion Functions in SQL Server – SQL Server Tutorial

CONVERSION FUNCTIONS  :-

This functions is used to one type to another type.

Cast ( ) Function in SQL Server with Examples:-

Syntax  :-  cast (expr as type)

Example :- Select ename+earns+ cast(sal as varchar) from emp

Output :-

• Smith earns 2000
• Anu earns     4000

Example :-

Select ename+joined on +cast(hiredate as varchar) from emp.

Select ename+joined on + Date name (dw,hiredate) from emp.

Convert ( ) Function in SQL Server with Examples:-

Syntax :  Convert(targettype,source value)

Example :-

• Select convert (int,10.2345)
•         ↓                 
• Output →10
• Select convert(varchar,getdate())
•           ↓
• Output→ OCT, 24, 2009