Built-in Functions → date
date() is a scalar date function that returns a date value given a string. The date() function takes a string representing a date in the en-US locale format. The string expresses the date as yyyy-MM-dd.
Signature
date(string exp)
The following table illustrates the date() parameter:
| Parameter | Description |
|---|---|
| string exp | an expression evaluating to a string |
Returns
date
Example
Convert December 24, 2001 11:55:12.000 pm to a value of type date.
date("2001-12-24 23:55:12.000")