php date conversion mysql [duplicate]

Question

Possible Duplicate:
Managing date formats differences between PHP and MySQL

I am using jQuery ui datepicker

and initialized with following format

$("#task_date").datepicker({dateFormat : "m/d/y",
            showOn: "button",
            buttonImage: "<?= base_url(); ?>assets/img/calendar.png",
            buttonImageOnly: true
        });

so the date format is in "m/d/y" ,how can i convert it to mysql date format ?

also i need to convert from mysql date format to "m/d/y" ...

hjpotter92 · Accepted Answer · 2012-07-14 11:10:50Z

2

Change dateFormat : "m/d/y" to

dateFormat : "yy-mm-dd"    //Which is same as PHP's 'Y-m-d' or '2012-07-14'

And, for converting to m/d/y format(in jQuery), you'll need to do:

var date = $('#task_date').datepicker({ dateFormat: 'dd-mm-yy' }).val();

Date conversion(in jQuery and in PHP)

edited Jul 14, 2012 at 11:10

answered Jul 14, 2012 at 10:54

hjpotter92

81.1k36 gold badges148 silver badges188 bronze badges

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

2 Comments

Gntem Over a year ago

this would save so much coding, +1

Red Over a year ago

pardon me , but its requirement ..

Collectives™ on Stack Overflow

php date conversion mysql [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related