
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. |