mysql timestamp code example
Example 1: mysql CURRENT_TIMESTAMP()
CURRENT_TIMESTAMP()
Example 2: mysql timestamp to date
-- Use the FROM_UNIXTIME() function in MySQL
select from_unixtime(timestamp) from my_tbl;
Example 3: php mysql timestamp format
date("Y-m-d H:i:s", strtotime($_POST['timestamp']));
Example 4: date vs datetime
DATE : YYYY-MM-DD format
DATETIME : YYYY-MM-DD HH:MM:SS format
TIMESTAMP : X s from 1970 format
TIME : HH:MM:SS format
Example 5: timestamp mysql
1970-01-01 00:00:01