php - How to save integer in MySQL timestamp column in Wordpress? -

php - How to save integer in MySQL timestamp column in Wordpress? -

i created table wordpress database within plugin with:

global $wpdb; require_once( abspath . 'wp-admin/includes/upgrade.php' ); global $charset_collate; $table_name = $wpdb->prefix .'tablename'; $sql="create table ".$table_name." ( ... date timestamp not null default current_timestamp(), ... ) $charset_collate; "; dbdelta($sql);

that works fine. when seek save integer values representing date saves "0000-00-00 00:00:00" except in 1 case saves right date: "2014-01-11 01:59:00". integer values valid timestamp dates (int(1401110159), int(1400525576), int(1400510041), ...). here code i'm trying insert rows:

$wpdb->$table_name=$table_name; $wpdb->insert($table_name, array( ... "date" => $my_date_integer_variable, ... ));

anyone knows what's causing error?

mysql expects timestamps in y-m-d h:i:s format when insert not integer format. ie. 2014-10-24 23:23:34

you can conversion int date time format with:

date('y-m-d h:i:s', 1401110159)

in case:

$wpdb->insert($table_name, array( ... "date" => date('y-m-d h:i:s', $my_date_integer_variable) ... ));

php mysql wordpress timestamp