DATE_TO_CHAR

Previous Next

Converts a datetime value to a character string of a specific format.

Syntax

DATE_TO_CHAR( datetime, io-format )

Example

DATE_TO_CHAR( start_date, 'MM/DD/YY' )

 

DATE_TO_CHAR is a convertible function resolved by USoft and thus supported on all RDBMS platforms. However, its exact behaviour partly depends on the underlying RDBMS function.

 

 

collapseOracle
collapseSQL Server
collapseODBC
collapseJDBC, Derby

 

See also

SQL Functions