converting date format using javascript

Question

I have a simple textfield with the type defied to be as date which attached with a jquery datepicker(). Now i have set the dateFormat() to be dd-mm-yy. All this works fine. But as i know MySql requires date in yyyy-mm-dd. So i was just wondering if i can convert that date format either using php or javascript to enter into the database.

E.g var date = $('#order_date').val(); gives value 26-2-2012. I need to convert this into 2012-02-26.

Note: There is also a 0 being added to the month.

Gijs P · Accepted Answer · 2012-02-26 19:16:32Z

2

Use PHP:

$date = $_POST['date']; // e.g. 06-08-2011
$mysql_date = date('Y-m-d', strtotime($date));

or

$date = explode('-', $_POST['date']);
$mysql_date = $date[2].'-'.$date[1].'-'.$date[1];

use $mysql_date to insert into the database.

answered Feb 26, 2012 at 19:16

Gijs P

1,4701 gold badge13 silver badges32 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 11:56:42Z

2

You can do in javascript by parsing the input and loading it into a Date() object, and then using the getMonth, getDate, and getFullYear functions, as follows:

        //Assume input is dd-mm-yyyy
        var dateParts = $('#order_date').val().split("-");
        var date = new Date(dateParts[2], (dateParts[1] - 1), dateParts[0]);

        //format using getMonth(), getDate() and getFullYear() methods)
        var formattedMonth = date.getMonth() + 1 < 10 ? '0' + (date.getMonth() + 1) : (date.getMonth() + 1);
        var formattedDate = date.getDate() < 10 ? '0' + date.getDate() : date.getDate();
        var output = date.getFullYear() + '-' + formattedMonth + '-' + formattedDate;

You can see more at this excellent StackOverflow post

edited May 23, 2017 at 11:56

CommunityBot

11 silver badge

answered Feb 26, 2012 at 19:21

Joe Alfano

10.3k6 gold badges31 silver badges40 bronze badges

Comments

hitesh israni · Accepted Answer · 2012-02-26 19:57:08Z

-1

did u try date.format("yyyy-mm-dd"); ? u can also use "isoDate" in place of "yyyy-mm-dd"

and if u are using mysql u can use DATE_FORMAT(date,'%Y-%m-%d')

edited Feb 26, 2012 at 19:57

answered Feb 26, 2012 at 19:06

hitesh israni

1,7524 gold badges26 silver badges49 bronze badges

2 Comments

ThiefMaster Over a year ago

Yeah, because date is a string, not a Date object.

hitesh israni Over a year ago

i figured out that u must create a format function. in that case Joe's answer will work.

Collectives™ on Stack Overflow

converting date format using javascript

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related