Progress
SQL-92
Guide and Reference
TO_CHAR Function
Converts the given expression to character form and returns the result. The primary use for TO_CHAR is to format the output of date-time expressions through the format_string argument.
SYNTAX
expression
Converts to character form. It must evaluate to a value of the date or time data type to use the format_string.
format_string
Specifies the format of the output. See the "Date-format Strings" section and the "Time-format Strings" section in "SQL-92 Language Elements" for more information on format strings.
SQL ignores the format string if the
expression
argument does not evaluate to a date or time.NOTES
- The first argument to the function can be of any type.
- The second argument, if specified, must be of type CHARACTER.
- The result is of type CHARACTER.
- The
format
argument can be used only when the type of the first argument is DATE.- If any of the argument expressions evaluates to null, the result is null.
COMPATIBILITY
Progress Extension
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |