CHAR(a,t) 
The CHAR(a,t) function (conversion function) converts a date, time or time stamp value (expression a) in a character string (data type CHAR) using the format for date values, time values, or timestamp values specified in t.
a, t |
Result of the CHAR(a,t) Function |
|---|---|
a |
The current date and time format is used for the value a. |
a is a NULL value |
NULL value |
t is the format for date, time or time stamp values |
This format is used for the value a. |