change date format on json format

Question

I want to change date format in json when i bind the result .

My script

$.ajax({
      type: "POST",
      async: false,
      url: "<?php echo site_url(); ?>admin/get_mail_contents",
      data: datastring,
      cache: false,
      success: function (result) {
          alert(result);
          var result = $.parseJSON(result);
          console.log(result.from);                                    
          $('#content').html('');
          $("#content").append('<div class="mail-toolbar clearfix"> </div><div class="divider"></div><div class="pad5A clearfix mrg10B"> <i class="glyph-icon icon-clock-o mrg5R"></i> ' + result['0']['start_time'] + ' , ' + result['0']['start_date'] + '</div></div> </div>');
      }
});

My actual out put is 15:37:00 , 2017-07-25 and i want to print 15:37 , 25-07-2017 in view how to change in json .

we can not change in json , i tried like date('d-m-Y',strtotime(result['0']['start_time'])); i already tried this in other page and it work but if i use it in json it not work. — dipti
– dipti, Commented Jul 26, 2017 at 7:19

Arun Kumaresh · Accepted Answer · 2017-07-26 07:37:26Z

1

Try this

var d = new Date(result['0']['start_date'] +' '+ result['0']['start_time']);

console.log(d.getHours() + ':' + d.getMinutes());

console.log((d.getDate()) + '-' + (d.getMonth() + 1) + '-' +  d.getFullYear());

edited Jul 26, 2017 at 7:37

answered Jul 26, 2017 at 7:21

Arun Kumaresh

6,2966 gold badges36 silver badges50 bronze badges

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

7 Comments

dipti Over a year ago

ok for time it work perfectly but now i want to show date like 25-07-2017 how can i get, i use d.getDate() but it only return 25(mean current date only)

Arun Kumaresh Over a year ago

i think result['0']['start_time'] has the date you want so can directly use that

dipti Over a year ago

no i use result['0']['start_time'] for time and result['0']['start_date'] for date ,i use two field for date and time in my table.

dipti Over a year ago

yes i use your answer for time ,and result['0']['start_date'] also return 2017-07-25 but i want d-m-Y format 25-07-2017 how i get

dipti Over a year ago

i follow your answer it only return year and i add likeconsole.log(d.getHours() + ':' + d.getMinutes() + 1 + '-' + d.getDate() + '-' + d.getMonth() + '-' + d.getFullYear()); but in place of month it return 6 but in my table it has 7

|

darkash · Accepted Answer · 2017-07-26 07:22:15Z

0

I suggest you try moment.js from https://momentjs.com/

It's easy to use to transform your formatted date to another formatting

Here's what I tried on my browser console

$.getScript("moment.js");
dt = new Date("15:37:00 , 2017-07-25");
moment(dt).format("HH:mm , DD-MM-YYYY");

and it will output as something like this:

"15:37 , 25-07-2017"

Hope this helps

answered Jul 26, 2017 at 7:22

darkash

1611 gold badge1 silver badge11 bronze badges

Comments

Osama · Accepted Answer · 2017-07-26 07:44:39Z

0

Use split function to create array of your date then rearrange values then create string from that array

 var date_array=result['0']['start-date'].split('-');
 var date_string=date_array[2].'-'.date_array[1].'-'.date_array[0];

Then use the date_string instead of result['0']['start_date']

answered Jul 26, 2017 at 7:44

Osama

3,0301 gold badge15 silver badges16 bronze badges

Collectives™ on Stack Overflow

change date format on json format

3 Answers 3

7 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

7 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related