jquery ui datepicker date format

Question

How to convert jquery UI datepicker date format for mysql-phpmyadmin datetime type field (default) format?

please help.

Thanks.

Geoffrey Hale · Accepted Answer · 2015-06-25 23:15:30Z

21

When you are initializing the date time picker, you can pass the format.

$( ".selector" ).datepicker({ dateFormat: 'yy-mm-dd' });

jQuery UI API Documentation > Datepicker dateFormat

Or after init:

//getter
var dateFormat = $( ".selector" ).datepicker( "option", "dateFormat" );
//setter
$( ".selector" ).datepicker( "option", "dateFormat", 'yy-mm-dd' );

Also according to MySQL Reference Manual:

MySQL retrieves and displays DATE values in 'YYYY-MM-DD' format.

edited Jun 25, 2015 at 23:15

Geoffrey Hale

11.7k5 gold badges46 silver badges49 bronze badges

answered Jul 28, 2011 at 11:50

Jude Cooray

19.9k21 gold badges85 silver badges128 bronze badges

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

1 Comment

Pathros Over a year ago

what about the time? How do you format to yyyy-mm-dd hh:mm:ss and set the today default?

Matt · Accepted Answer · 2011-07-28 11:49:26Z

4

From the jQuery UI site:

http://jqueryui.com/demos/datepicker/#date-formats

$(yourInput).datepicker({dateFormat: 'yy-mm-dd'})

answered Jul 28, 2011 at 11:49

Matt

44.1k6 gold badges105 silver badges103 bronze badges

Collectives™ on Stack Overflow

jquery ui datepicker date format

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related