Returns the number of days since 1970-01-01.
Sample usage
UNIX_DATE(Order Date)
Syntax
UNIX_DATE(date_expression)
Parameters
date_expression- a Date or Date & Time field or expression.
Return data type
Number
Examples
| Example formula | Output |
|
|
18569 |
Notes
This function is not available for compatibility mode date types.
UNIX_DATE ignores the time parts of a Date & Time field or expression.