HTML5 and MySQL date format

Question

I am unable to insert HTML5 default date format(mm/dd/yyyy) in mysql(YYYY-mm-dd).Please help is there any way to insert the html5 date into mysql. Or is it possible to change the html5/mysql date format?

<?php
  $name=$_POST['name'];
  $email=$_POST['email'];
  $password=$_POST['password'];
  $gender=$_POST['gender'];
  $bday=$_POST['bday'];
  include('connect.php');
  $y=mysql_query("insert into users values('$name','$email','$password','$gender','$bday')");
?>

What server-side language are you using to do this? Do you have any code to show? As this question stands, it's not a good format for Stack Overflow. Please read the **[FAQ](http://stackoverflow.com/faq)** for more details. — brbcoding, Apr 18 '13 at 20:06
Mysql has a fuction to format dates. [DATE_FORMAT](http://www.w3schools.com/sql/func_date_format.asp) — Luigi Siri, Apr 18 '13 at 20:06
http://stackoverflow.com/questions/7372038/is-there-any-way-to-change-input-type-date-format — RafH, Apr 18 '13 at 20:07

score 3 · Answer 1 · answered Apr 18 '13 at 20:22

3

<?php

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

?>

answered Apr 18 '13 at 20:22

AbsoluteƵERØ

7,816
2
24
35

Luigi Siri · Accepted Answer · 2013-04-18T20:28:13.607

2

To change MySQL date format in your query you can use:

...since we can see your code

EDIT:

 mysql_query("insert into users values('$name','$email','$password','$gender',".date('Ymd',$bday))

Hope this helps...

edited Apr 18 '13 at 20:28

answered Apr 18 '13 at 20:14

Luigi Siri

2,068
2
19
27

This function expects a MySQL date format already if I'm not mistaken. – AbsoluteƵERØ Apr 18 '13 at 20:19

HTML5 and MySQL date format

2 Answers2