Version: 10.1

USFormat.CharToDate

note

This article is about the CharToDate method of the USFormat internal component.

Converts a character string to a date.

Returns the result of the conversion as a date.

Syntax

SELECT USFormat.CharToDate(
    *string*
,   *date-format-pattern*
)

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

Example

SELECT USFormat.CharToDate(
         '12-MAR-2019'
,        'DD-MON-YYYY'
)

USFormat.CharToDate​