Convert SQL datetime to string or Date object

Asked Mar 21 '16 at 12:17

Active Mar 21 '16 at 19:51

Viewed 311 times

I'm trying to get this SQL datetime (yyyy-MM-ddTHH:mm:ssZ) to be somewhat readable. (perhaps yyyy-MM-dd HH:mm)

Now it displays like this:

2011-10-28T11:03:52Z

I'm really confused on how to display it like this

2011-10-28 11:03

I got this html snippet.

<tbody bgcolor="#eef2f7">
 <!-- ko foreach: $data -->
  <tr>
     <td class="messageCell" style="text-align:right;">
         <label data-bind="text: $data.updated_time"></label>
     </td>
  </tr>
 <!-- /ko -->
</tbody>

I got this javascript

GET('<!--%root%-->/API/item,
        function (items, textStatus, request) {
            var invoiceeModel =
                contracts.map(function (data) {
                    return {
                        updated_time: ko.observable(data.updated_time)
                    };
        });

Pointers, tips and code-snippets are warmly welcome!

edited Mar 21 '16 at 19:51

Jeroen

60,696
40
206
339

asked Mar 21 '16 at 12:17

Awots

If you are using JS to get the data from DB you can use moment.js for date manipulation – Abhik Chakraborty Mar 21 '16 at 12:24
@SubliemeSiem I want to convert datetime to a string or a js Date object. Not the other way around. – Awots Mar 21 '16 at 12:52
@SubliemeSiem I'm really sorry, i figured it out! I read your link completely wrong first time. Problem was solved thanks to you! – Awots Mar 21 '16 at 13:18
@Awots Good to hear! – SubliemeSiem Mar 21 '16 at 13:21

Convert SQL datetime to string or Date object

0 Answers0