This page will show the different conversion functions used with the different database vendors that we use.

 

Oracle:

 

 

Name	Example
CAST Converts one built-in datatype or collection type value into another built-in datatype or collection-type value	Format: CAST(<string / column> AS <Data Type>) SELECT CAST(123456 AS VARCHAR2(10))   FROM DUAL;
TO_CHAR Convert Datatype to String	Format: To_CHAR(string / colum, <format>) Return VARCHAR2 SELECT TO_CHAR(SYSDATE, 'MM/DD/YYY') FROM DUAL;

 

 

 

 

SQL Server