Date Format D
You can output date expressions using a D format specification. The date format specification is a D or d, followed by a quoted string template indicating exactly how a specific date would be printed. Ingres requires that you delimit the template with single (') or double (") quotation marks; single quotes are recommended for consistency with requirements for quoting string constants.
The date is left justified by default, but by specifying the optional plus sign (+), you can right justify the date. The template must be surrounded with single quotes.
The syntax of a date template is:
[-|*|+] D|d 'template'
where:
'template'
Specifies a string of characters representing a sample absolute date and time