datatable time is different from database time

-------

5y1k.NET

eI am trying to show database time in the datatable but issue is show the current time

see database time

see datatable time

.cshtml

$.ajax({
url: strUrl,
type: 'POST',
success: function (result) {
console.log("inside the success method")
$('#').DataTable({
data: result,
columns: [
{ data: "StartFromTime" },
{ data: "EndToTime" },
],
"aoColumnDefs": [
{
"aTargets": [0],
//title: "StartFromTime",
"mRender": function (row) {//data
//console.log("inside the date and time:" + data + ":" + type);
//console.log(moment(row.StartFromTime).format('DD/MM/YYYY hh:mm:ss'));
//console.log("StartFromTime:" +moment(row.StartFromTime).format('hh:mm:ss'));
//console.log("innnn");
//console.log(row);
////console.log(data);
//console.log(type);
//console.log(moment(row).format('hh:mm:ss'));
//var date = new Date(parseInt(data.substr(6)));
//console.log("date:" + date);
//return date.getDate();
return moment(row.StartFromTime).format('hh:mm:ss');
}
},
{
"aTargets": [1],
"mRender": function (row) {//data
return moment(row.EndToTime).format('hh:mm:ss');
}
},

model

public class TimeList
{
public int Id { get; set; }
public DateTime StartFromTime { get; set; }
public DateTime EndToTime { get; set; }

how to show the database time in datatable?

problem is moment() is built in jquery function that is the reason show the current time I want to show database time

I want to show database time in datatable?

12 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
If nothing works for you then extract time from datetime in controller and then bind datatable.
Sachin Singh5y ago
paas static "1900-01-01 07:00:11.000" in function, it is working fine.i have tested it twice.
-------5y ago
Cannot read property 'split' of undefined
Sachin Singh5y ago
after analyzing your issue
i created below function which fits perfact for your scenario , tested and works perfect. paste the function anywhere in script and do as below.
"mRender": function (row) {
       var time = sqlToJsDate(row);
       return time;

   }
   function sqlToJsDate(sqlDate) {

       debugger;

       var sqlDateArr1 = sqlDate.split("-");




       var sqlDateArr2 = sqlDateArr1[2].split(" ");




       var sqlDateArr3 = sqlDateArr2[1].split(":");



       var sHour = sqlDateArr3[0];

       var sMinute = sqlDateArr3[1];
       var sqlDateArr4 = sqlDateArr3[2].split(".");
       //format of sqlDateArr4[] = ['ss','ms']

       var sSecond = sqlDateArr4[0];

       return sHour+":" +sMinute +":"+ sSecond;





   }
-------5y ago
not work I try this yesterday but not work

console log:
row:/Date(-2208986989000)/
gettime:Invalid Date
data7:41

code:

console.log("row:" + row);

var aDate = new Date(row);
console.log("gettime:" + aDate);
eturn aDate.getTime();
Sachin Singh5y ago
now nothing left
use below code
"mRender": function(row){
   var aDate= new Date(row);

   return aDate.getTime();
       }
-------5y ago
not work sachin

please refer this moment.js and can you tell me which function is used:

https://momentjs.com/

see console log:

row:/Date(-2208986989000)/
h:NaN
m:NaN
s:NaN
dateString:NaN:NaN:NaN
data7:41
"aoColumnDefs": [
                             {
                                 "aTargets": [1],

                                 "mRender": function (row) {

                                     console.log("row:" + row);

                                     var aDate = new Date(row);
                                     var dateString = '';

                                     var h = aDate.getHours();
                                     var m = aDate.getMinutes();
                                     var s = aDate.getSeconds();

                                     console.log("h:" + h);
                                     console.log("m:" + h);
                                     console.log("s:" + h);


                                     if (h < 10) h = '0' + h;
                                     if (m < 10) m = '0' + m;
                                     if (s < 10) s = '0' + s;

                                     dateString = h + ':' + m + ':' + s;

                                     console.log("dateString:" + dateString)

                                     return dateString;
Sachin Singh5y ago
it seems as if moment js is creating chaos, simply use plain javascript and test
"mRender": function(row){
var aDate= new Date(row);
var dateString = '';

var h = aDate.getHours();
var m = aDate.getMinutes();
var s = aDate.getSeconds();

if (h < 10) h = '0' + h;
if (m < 10) m = '0' + m;
if (s < 10) s = '0' + s;

dateString = h + ':' + m + ':' + s;
return dateString;
    }
-------5y ago
hello sachin

not work
"mRender": function (row) {
                                     var date = new Date(row);

                                      console.log("date:" + date);
                                      console.log("print data:" + moment(date).format("HH:mm:ss"));
                                      console.log("row:" + row);

                                      return moment(date).format("HH:mm:ss");
see consolelog
date:Invalid Date
print data:Invalid date
row:/Date(-2208986989000)/
data7:41
plese help
Sachin Singh5y ago
okk then don't parse try below code
"mRender": function(row){
var date=new Date(row);


      return moment(date).format("HH:mm:ss");
    }
-------5y ago
hello sachin

your code is not work

showing the invalida date
code:
"mRender": function (data, type, row) {
                                    console.log("type:" + type);
                                    console.log("row:" + row);

                                    var date = new Date(Date.parse(row));

                                    console.log("datetime:" + moment(date).format("HH:mm:ss"));

                                    return moment(date).format("HH:mm:ss");
see below console log:

type:display
row:[object Object]
datetime:Invalid date
data7:41
Sachin Singh5y ago
hii try something like shown below
"mRender": function(row){
var date=new Date(Date.parse(row));


      return moment(date).format("HH:mm:ss");
    }