Codeigniter MySQL incorrect datetime insertion

Question

In codeigniter before database insertion, datetime is correct.

05-08-2019 17:30:00

But in database it's 05-08-2019 5:30:00 I tried to add timestamp in config.php.

date_default_timezone_set('Asia/Kolkata');

But no change in this behavior.

can you show your date_format() code how you insert it in DB? — M.Hemant
– M.Hemant, Commented Aug 6, 2019 at 2:51
$data['cur_time']=date('y-m-d h:i:s'); $this->db->insert('tb_user', $data); — imran
– imran, Commented Aug 6, 2019 at 4:20
if you insert it from mysql timestamp auto update, then check your server timezone. — Devsi Odedra
– Devsi Odedra, Commented Aug 6, 2019 at 4:20

M.Hemant · Accepted Answer · 2019-08-06 04:26:43Z

1

Try this,

$data['cur_time']=date('Y-m-d H:i:s');//changes `H` & `Y`
$this->db->insert('tb_user', $data);

H will give you Hour (00 to 23)
h will give you Hour (00 to 12)
Y Year as a numeric, 4-digit value
y Year as a numeric, 2-digit value

answered Aug 6, 2019 at 4:26

M.Hemant

2,3551 gold badge11 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

I think this will work. Will try by inserting new data this afternoon