date

Returns a date value given a string.

Example

Convert December 24, 2001 11:55:12.000 pm to a value of type date.

date("2001-12-24 23:55:12.000")

Syntax

date(string expr s_date)
  • s_date : expression evaluating to a string

    Returns

    date

Notes

Function date takes a string representing a date in the en-US locale format. The string expresses the date as yyyy-MM-dd.