Link Search Menu Expand Document

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