Jquery/PHP + Create MySQL Date Type

Question

I have a site that people join and enter their birthdate which I want to store in MySQL as a date Type.

The data I have is

Day - eg: 1 or 11, 23 etc
Month - eg: March or April or December
Year - eg: 1975 or 1964 or 1944 etc

thus eg: 3 March 1966

How can I convert this into a format that can be saved into as a MySQL date type?

thankyou

Community · Accepted Answer · 2023-11-17 20:42:18Z

1

$datetime = DateTime::createFromFormat('j F Y', '3 March 1966');
echo $datetime->format('Y-m-d');

Reference:

CommunityBot

11 silver badge

answered Feb 21, 2013 at 1:04

John Conde

220k100 gold badges464 silver badges504 bronze badges

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

Comments

Bhaskar Bhatt · Accepted Answer · 2013-02-24 18:37:51Z

0

it can be created using date() and strtotime() functions

 $mysql_date= date("Y-m-d",strtotime("3 March 1996"));

answered Feb 24, 2013 at 18:37

Bhaskar Bhatt

1,48113 silver badges19 bronze badges