UNIXTIME

Converts a DATE or TIMESTAMP to whole Unix epoch seconds as an INTEGER; sub-second detail is discarded. With no argument, gives the epoch seconds at which the query's connection was opened - the same value as UNIXTIME(NOW()).

Category: Date & Time Functions

Syntax

UNIXTIME(date)

UNIXTIME()

Arguments

• date temporal Date or timestamp value to evaluate.

Returns

INTEGER — Returns the computed result as INTEGER.