Link Search Menu Expand Document

TO_DATE

Converts a string to DATE type.

Syntax 

TO_DATE(<string>)
Parameter Description
<string> The string to convert to a date. The string format should be: ‘YYYY-MM-DD’

Example 

SELECT
	TO_DATE('2020-05-31') AS res;

Returns: 2020-05-31