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

TO_CHAR ( expresion [ , format_string ] ) 

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

COMPATIBILITY

Progress Extension


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095