Format date strings

A date-formatting mask specifies a format to apply to some date value.

This mask is a combination of the following formats.
dd
Day of the month as a two-digit number (01 - 31)
ddd
Day of the week as a three-letter abbreviation (Sun - Sat)
mm
Month as a two-digit number (01 - 12)
mmm
Month as a three-letter abbreviation (Jan - Dec)
yy
Year as a two-digit number (00 - 99)
yyyy
Year as a four-digit number (0001 - 9999)
ww
Day of the week as a two-digit number (00 for Sunday, 01 for Monday, 02 for Tuesday 06 for Saturday)

Any other characters in the formatting mask are reproduced literally in the result.

When you use rfmtdate() or rdefmtdate() to format DATE values, the function uses the date end-user formats that the GLDATE or DBDATE environment variable specifies. If neither of these environment variables is set, these date-formatting functions use the date end-user formats for the locale. The default locale, U.S. English, uses the format mm/dd/yyyy. For a discussion of GLDATE and DBDATE environment variables, see the Informix® GLS User's Guide.