TO_UNIX_TIMESTAMP
Converts a string to a UNIX timestamp.
Syntax
TO_UNIX_TIMESTAMP(<string>)
| Parameter | Description |
<string> | The string format should be: ‘YYYY-MM-DD HH:mm:ss’ |
Example
SELECT
TO_UNIX_TIMESTAMP('2017-11-05 08:07:47');
Returns: 1509869267