USFormat.DateToChar

Converts a date value to a string.

Returns the result of the conversion.

Syntax

SELECT USFormat.DateToChar(

         date

,        date-format-pattern

)

Both string and date-format-pattern are required. Date-format-pattern must be one of the USoft format patterns used for date values.

Example

SELECT USFormat.CharToDate(

         sysdate

,        'DD-MM-YY'

)

The return value of this statement is:

28-03-2019