CHAR(a,t)

CHAR(a,t) is a function (conversion function) that converts the date values, time values, or timestamp values to a character string (expression a) with the format for date values, time values, or timestamp values specified in t.

Result of the CHAR(a,t) function

CHAR(a)

The current date and time format is used for the value a.

a is the NULL value

NULL Value