select from_unixtime(0);
from_unixtime(0)
1970-01-01 00:00:00
select unix_timestamp('1969-12-31 14:00:01');
ERROR HY000: Received an invalid value '1969-12-31 14:00:01' for a UNIX timestamp.
select unix_timestamp('1970-01-01 00:00:01');
unix_timestamp('1970-01-01 00:00:01')
1
|