Progress
SQL-92
Guide and Reference
Date-time Format Strings
The TO_CHAR scalar function supports a variety of format strings to control the output of date and time values. The format strings consist of keywords that SQL interprets and replaces with formatted values.
The format strings are case-sensitive. For instance, SQL replaces ’DAY’ with all uppercase letters, but follows the case of ’Day’.
Supply the format strings, enclosed in single quotation marks, as the second argument to the TO_CHAR function. For example:
EXAMPLE
For information on the TO_CHAR function, see SQL-92 Functions."
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |