CHAR[(N)]

CHAR[(N)]

DATE

DATETIME

TIME

SIGNED [INTEGER]

UNSIGNED [INTEGER]

DECIMAL[(M[,D])]

There are 2 Functions used to explicitly Cast your Data into another data type

CAST(expression AS cast_type)

CONVERT(expression, cast_type)

Cast Types

An expressions can be as simple as a single field or as complex as a merger of 2 fields wrapped in a function call

SELECT CAST(“2022-04-02” AS DATE);

SELECT CONVERT(“2022-04-02” , DATE);

Explicitly Transforming Your Data