how to change the date format of my bootstrap datetimepicker

Question

i am new in bootstrap datetimepicker. How would i change its defaut time format?. I have a default date format of mysql (yyyy/mm/dd). I want also to change my datetimepicker so that it co-inside my database date format.

Here is the bootstrap date time picker:

<form id="date">
<div class="form-group">
     <label class="control-label col-sm-3" for="pbdate">Birthdate:</label>
       <div class="col-sm-5">
         <div class="input-group date" data-provide="datepicker">
           <input type="text" class="form-control" id="pabdate" name="pabdate" placeholder="Birthdate" required>
              <div class="input-group-addon">
                <span class="glyphicon glyphicon-th"></span>
              </div>
         </div>
       </div>
</div>
</form>

here is the format i want:

$('.datepicker').datepicker({
    format: 'yyyy/mm/dd'    // pass here your desired format
 });

Here is my ajax:

$.ajax({
    url: siteurl+"sec_date/mydate",
    type: "POST",
    data: $('#date').serialize(),
    dataType: "JSON",
        success: function(data) {
     }
   )};

When i var_dump it in my controller because i am using codeigniter the output is still mm/dd/yyyy

Answer 1

Try this:

$('.datepicker').datepicker({
    format: 'dd/mm/yyyy'    // pass here your desired format
 });

Note: Database default format of date is D-M-Y

You can change it in controller function to database supported format like:

$DB_date = date('Y-m-d', strtotime($date_picker_date));