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