Form Date Input Field Format

Question

My HTML Form has a

<input type="date">

Whereas my mysql database's table column is a date, which is stored in the format YYYY-MM-DD, however, the form submits the date field as DD-MM-YYYY, which MYSQL rejects.

Is there any way to get around this or to convert the date values into the correct format, or do i have to use another plugin to accomplish this? (e.g jquery ui)

It will automatically stored in database as YYYY-MM-DD. Go ahead. No need to change the format. — Nikz, Jan 03 '15 at 06:43
so if the problem its the date format give a try to [this](http://momentjs.com) it use javascript to change pretty easy the date format and languaje — Ethaan, Jan 03 '15 at 06:44
@deena, the thing is mysql date columns format is YYYY-MM-DD, but my chrome date input is in DD-MM-YYYY, therefore if the data gets submitted to MYSQL, the query fails as the format is not right. — userxxxso, Jan 03 '15 at 06:44
Guys no need to change the format.. You just try to insert the value from the date field to database. It will save in the YYYY-MM-DD format — Nikz, Jan 03 '15 at 06:46
@nikz, what about in safari browsers, whereby users enter the date manualy, i dont think that will work — userxxxso, Jan 03 '15 at 06:48

Sadikhasan · Accepted Answer · 2015-01-03T06:53:38.963

1

In PHP

var $date = $your_input_date; //e.g. 03-01-2015
$date = date('Y-m-d', strottime($date));

http://php.net/manual/en/function.date.php

edited Jan 03 '15 at 06:53

answered Jan 03 '15 at 06:45

Sadikhasan

18,365
21
80
122

hi there, i dont need the time, just the date, which means i remove H:i:s? – userxxxso Jan 03 '15 at 06:47
Yes you can remove `H:i:s`. Check my updated answer – Sadikhasan Jan 03 '15 at 06:48

score 0 · Answer 2 · edited May 23 '17 at 12:25

0

you can use javascript function to change date format

function reformatDate(dateStr)
{
  dArr = dateStr.split("-");  // ex input "2010-12-31"
  return dArr[2]+ "-" +dArr[1]+ "-" +dArr[0]; //ex out: "31-12-2010"
}

Check link for more details

edited May 23 '17 at 12:25

Community

1
1

answered Jan 03 '15 at 06:44

Himanshu

4,327
16
31
39

i see, is there a way whereby i can detect aLL date formats the user uses and convert them to YYYY-MM-DD? but pertaining to this question, your answer is correct. – userxxxso Jan 03 '15 at 06:46

score 0 · Answer 3 · answered Jan 03 '15 at 06:44

You will need to insert the date in the database field in the format Y-m-d H:i:s. Hence on receiving the date from the form and parse it using the date function something like this: date('Y-m-d H:i:s', strtotime($date)) //where $date is the date field from the form

score 0 · Answer 4 · answered Jan 03 '15 at 07:00

MySQL has a function STR_TO_DATE, so you can convert at once in the query:

INSERT INTO atable (datetimefield)
VALUES (STR_TO_DATE('03-01-2015', '%d-%m-%Y'))

Mysql Documentation

Or you can use JQuery UI datepicker which has an option for an alternative field, where you can store the date in the correct format.

Form Date Input Field Format

4 Answers4