将日期转换为php中的sql格式并将其存储到数据库[复制]

Question

This question already has an answer here:

• Convert one date format into another in PHP 15 answers

I have date time picker in html that return me the date when i retrieve data in php page

$date=$_POST['date'];
echo $date;

it return the output in this format

13 November 2015

i want to convert it to store in mysql table

how can i convert it to sql format to store because when i am trying to store this date mysql stores 0000-00-00 by default. i can not take data type varchar because i have to create views according to date.

also i need the code to convert it again to this format to show data in this format.

</div>

Answer 1

use MySQL Str_To_Date :-

SELECT str_to_date('13 November 2015','%d %M %Y')

or try :-

$date=$_POST['date'];

insert into table (col) values (str_to_date($date,'%d %M %Y'))

or use PHP strtotime

$time = strtotime('13 November 2015');
$newformat = date('Y-m-d',$time);