TIME_TO_CHAR

Uses a format string to format a time. Returns the formatted time or portion of a time as a string.

TIME_TO_CHAR(format,time);

where ‘format’ is a time pattern and time is a time expression.

For information about time formats, see Date and Time Patterns.