CONVERT

Description

Convert an expression of one data type to another. (CONVERT in Transact-SQL).

Sample Source Pattern

Syntax

SQL Server

CONVERT ( data_type [ ( length ) ] , expression [ , style ] )  

Snowflake SQL

Snowflake SQL Documentation

CAST( <source_expr> AS <target_data_type> )

Examples

SQL Server

IN -> SqlServer_01.sql

SELECT CONVERT(INT, '1998') as MyDate

Result

MyDate |
-------+
1998   |

Snowflake SQL

OUT -> SqlServer_01.sql

SELECT
CAST('1998' AS INT) as MyDate;

Result

MYDATE |
-------+
1998   |

Casting date type to varchar

SQL Server

IN -> SqlServer_02.sql

SELECT CONVERT(varchar, getdate(), 1) AS RESULT;

Result

RESULT   |
---------+
12/08/22 |

Swowflake SQL

OUT -> SqlServer_02.sql

SELECT
TO_VARCHAR(CURRENT_TIMESTAMP() :: TIMESTAMP, 'mm/dd/yy') AS RESULT;

Result

RESULT   |
---------+
12/08/22 |

Casting date type to varchar with size

SQL Server

IN -> SqlServer_03.sql

SELECT CONVERT(varchar(2), getdate(), 1) AS RESULT;

Result

RESULT   |
---------+
07       |

Snowflake SQL

OUT -> SqlServer_03.sql

SELECT
LEFT(TO_VARCHAR(CURRENT_TIMESTAMP() :: TIMESTAMP, 'mm/dd/yy'), 2) AS RESULT;

Result

RESULT   |
---------+
07       |

The supported formats for dates casts are:

Date formats

Time formats

Date and time formats

Islamic calendar dates

If there is no pattern matching with the current code, it will be formatted to yyyy-mm-dd hh:mm:ss

Known Issues

No issues were found.

Related EWIs

No related EWIs.