How to add Date in MySQL with Codeigniter db->insert() method

Question

I am saving date of birth in MySQLusing my form with

db->insert()

method, but it's not properly inserted in the database. How can I save the input field value in the proper date format in MySQL? (In MySQL the type of dob is also set to "DATE".)

Kindly provide the code you are having trouble with.

Jared Farrish
– Jared Farrish

2013-03-21 05:12:56 +00:00
Commented Mar 21, 2013 at 5:12 — Jared Farrish
– Jared Farrish, Commented Mar 21, 2013 at 5:12

Elber CM · Accepted Answer · 2017-06-22 08:00:50Z

2

MYSQL DATE - A date in YYYY-MM-DD format

so you need to convert via sql or php

PHP

~~$date= date('YYYY-MM-DD',strtotime($old_date));~~

$date= date('Y-m-d',strtotime($old_date));

edited Jun 22, 2017 at 8:00

Elber CM

2986 silver badges21 bronze badges

answered Mar 21, 2013 at 5:14

Bhavin Rana

1,5824 gold badges22 silver badges40 bronze badges

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

Comments

Harjeet Jadeja · Accepted Answer · 2013-03-21 05:14:20Z

1

if you have taken your dateofbirth field's datatype as date then you have to insert date in yyyy-mm-dd format.

answered Mar 21, 2013 at 5:14

Harjeet Jadeja

1,6044 gold badges20 silver badges39 bronze badges

Collectives™ on Stack Overflow

How to add Date in MySQL with Codeigniter db->insert() method

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related