+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: timestamp (/showthread.php?tid=44007)
timestamp - El Forum - 07-30-2011
[eluser]mehwish[/eluser]
hi please tell me how do i insert values in database field with type timestamp. Like i am doing this way in codeigniter
Code:
$user_poll_query=array(
'description'=>$poll_query,
'creator_id'=>$user_id,
'valid_from'=>date('Y-m-d H:i:s','1299762201428'),
);
$this->db->insert('sl_polls',$user_poll_query);timestamp - El Forum - 07-30-2011
[eluser]fesweb[/eluser]
You are passing a string into the date() function, which requires a timestamp, or at least a number. Plus your unix timestamp is 3 digits too long.
Code:
'valid_from'=>date('Y-m-d H:i:s','1299762201428')
// should be more like this...
'valid_from'=>date('Y-m-d H:i:s', 1299762201) // no quotes
// or...
'valid_from'=>date('Y-m-d H:i:s', strtotime('2009-02-01'))