on submit change date format from dd M yy to "2015-01-28T00:00:00+00:00" datepicker

Question

I am currently using a datepicker in wordPress allowing the user to select a date. On submit, how can I change the current format of 'dd M yy' to something like 2015-01-28T00:00:00+00:00 so it can be submitted into a database later on. As well as check for validation, but I think this will be a different question.

Currently I have the following to declare the date picker :

//  triggers the calendar to open.
$(document).ready(function() {
    $('#deadline_date').datepicker({
        dateFormat : 'dd M yy',
        minDate: 0
    });
});

score 1 · Accepted Answer · edited May 23 '17 at 12:12

1

In your PHP code

$datetime= date("c", strtotime(" 2015-01-28"));
echo $datetime;  //Output :  2015-01-28T00:00:00+00:00

jQuery Code

var dateVar = "2015-01-28";
var date=new Date(dateVar);
var timeZone = date.getTimezoneOffset();
alert(date.getFullYear() + "-" + (date.getMonth() + 1) + "-" + date.getDate() + "T" + date.getHours() + ":" + date.getMinutes()  + ":" + date.getSeconds() + "." + date.getMilliseconds() + (timeZone > 0 ? "-" : "+") + Math.floor(Math.abs(timeZone) / 60) + ":" + Math.abs(timeZone) % 60);

Reference

edited May 23 '17 at 12:12

Community

1
1

answered Jan 27 '15 at 10:18

Sadikhasan

18,365
21
80
122

Sorry, but I am using JS not php. – Elina Lulle Jan 27 '15 at 10:21
I think wordpress made in `PHP` – Sadikhasan Jan 27 '15 at 10:23
yes it is, but my validation and on submit code is in a JS file :/ – Elina Lulle Jan 27 '15 at 10:24
That won't take the exact time.. It will fill the rest with 0s. – Gogol Jan 27 '15 at 10:33
Any suggestions on how I would do this in JS? @noc2spamツ – Elina Lulle Jan 27 '15 at 10:50
Check this link http://stackoverflow.com/questions/17807806/jquery-ui-datepicker-date-convert-to-rfc-3339-format – Sadikhasan Jan 27 '15 at 10:53
That does half help, but I would liek to use the year, month and day that the user has inputed using the datepicker, if that is possible. – Elina Lulle Jan 27 '15 at 11:10

on submit change date format from dd M yy to "2015-01-28T00:00:00+00:00" datepicker

1 Answers1