DATE_TO_CHAR

The DATE_TO_CHAR function converts a date to a string.

Syntax

DATE_TO_CHAR(format,date-expr);

where date-expr is a date expression that will be converted to a string.

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