TO_UNIXTIME
For DATETIME arguments: this function converts the value to its internal numeric representation (Unix Timestamp). For TEXT arguments: this function parses DATETIME from a string and returns the corresponding Unix timestamp.
Syntax
TO_UNIXTIME(<string>)
| Parameter | Description |
|---|---|
<string> | The string to be converted. |
Example
SELECT
TO_UNIXTIME('2017-11-05 08:07:47') AS TO_UNIXTIME;
Returns: 1509869267