PDO -> JSON object -> javascript - changing date format displayed

Question

The db table has column "lastlogin" saved in date format e.g. 2014-03-15 15:45:58.

Into the JSON [Object] is : lastlogin: "2014-03-15 15:46:58"

I need to display this value in format "15/03/2015 15:45:58" into my html table
and i don't need to alter this value inside a JSON [Object].

I want doing this with pure javascript code without using a library like moment.js, Date.js etc etc.

I write my code but there is another more practice code ?

my javascript code

function usersList() { 
$('#idsearch').attr("placeholder", "Find user by ID");
$('#my-table').empty();
$('#sectiontitle').html('Users list');
$('#my-table').append('<tbody><tr><th>Last login</th></tr></tbody>');

  $.getJSON('../../functions/users.php' , function(result) {

      $.each(result, function(index, array){

        var dateSplit = array['lastlogin'].split(" ");
        // create new array with 2 values
        // N.B. if the value was 2014-03-15T15:46:58 i use .split("T")

        var time = dateSplit[1]; // note the [1] for the second value in array dateSplit
        // create a var for the time value only ["15:46:58"]

        var dateSplit2 = dateSplit[0].split("-"); // note the [0] for the first value in array dateSplit
        // create a new array with 3 value ["2014", "03", "15"]

        var date = dateSplit2.reverse().join('/');
        // create a date var with values reversed and joined ["15/03/2014"]

$('#my-table > tbody:last').append('<tr><td>'+date+' '+time+'<td></tr>'); // show 15/03/2014 15:46:58

     });
  });
}

Can you clarify what you mean by *"without loading another JQuery script"*? — Wesley Murch, Mar 17 '14 at 14:27
@adeneo The question is : i now this is a "workaround" javascript code.. there is another best way ? — geomo, Mar 17 '14 at 14:28
@WesleyMurch i dont want load another jquery script in this page — geomo, Mar 17 '14 at 14:29
possible duplicate of [Where can I find documentation on formatting a date in JavaScript](http://stackoverflow.com/questions/1056728/where-can-i-find-documentation-on-formatting-a-date-in-javascript) — Wesley Murch, Mar 17 '14 at 14:31
Your not loading *another* Jquery script? This question makes no sense. — Liam, Mar 17 '14 at 15:18
@Liam i want use pure javascript code, not use script like moment.js, php.js, DateJS etc etc .. — geomo, Mar 17 '14 at 15:50

Adrian Preuss · Accepted Answer · 2014-03-17T14:48:18.110

1

Format with correct functions. Dont split, use Date:

 var date = new Date("2014-03-15 15:45:58"); // Replace with Database-Entry

http://www.w3schools.com/jsref/jsref_obj_date.asp

Example:

function usersList() { 
    $('#idsearch').attr("placeholder", "Find user by ID");
    $('#my-table').empty();
    $('#sectiontitle').html('Users list');
    $('#my-table').append('<tbody><tr><th>Last login</th></tr></tbody>');

    $.getJSON('../../functions/users.php' , function(result) {
        $.each(result, function(index, array) {
            $('#my-table > tbody:last').append('<tr><td>' + formatDate('d/m/Y H:i:s', new Date(array['lastlogin'])) '<td></tr>'); // show var date and time
        });
    });
}

function formatDate(format, date) {
    format = format.replace(/Y/g, date.getFullYear());
    format = format.replace(/m/g, date.getMonth());
    format = format.replace(/d/g, date.getDay());
    format = format.replace(/H/g, date.getHours());
    format = format.replace(/i/g, date.getMinutes());
    format = format.replace(/s/g, date.getSeconds());
    return format;
}

edited Mar 17 '14 at 14:48

answered Mar 17 '14 at 14:29

Adrian Preuss

3,228
1
23
43

"Format with correct functions." Well, thanks? What are the correct functions? – Anthony Grist Mar 17 '14 at 14:30
Cant read? Ive posted the right function! – Adrian Preuss Mar 17 '14 at 14:32
2

@AdrianPreuß Yes, I can read. You've converted a string to a Date object, that doesn't give them the output format asked for in the question. – Anthony Grist Mar 17 '14 at 14:32
@WesleyMurch I read the entire post and it doesn't address the question as asked, since it doesn't format anything at all - it just creates an object. – Anthony Grist Mar 17 '14 at 14:35
JavaScript's native date formatting methods leave a lot to be desired. The [Moment](http://momentjs.com/) library will format the date however the OP wants – Bojangles Mar 17 '14 at 14:43
Use a library to format or write a own function (check the update). You can use format what you want `d/m/Y H:i:s` or `d. M Y, H:i` for example. – Adrian Preuss Mar 17 '14 at 14:47
@AdrianPreuß chapeau! – geomo Mar 17 '14 at 14:58

PDO -> JSON object -> javascript - changing date format displayed

1 Answers1