Datetime value not showing properly in jQuery data table

Question

I want to get the timestamp in data table . how to format my datetime in the jquery datatable function?

sql server datatime data, how to edit the columns so that i cant get the proper datetime in the data time. i have tried with type: 'date-dd-mmm-yyyy', but its not working

 2018-11-23 07:49:35.073
     data type - date time

javascript

$(document).ready(function () {
                            $('#myTable').DataTable({
                                "ajax": {
                                    "url": "/Temperature/loaddata",
                                    "type": "GET",
                                    "datatype": "json"
                                },
                                "columns": [
                                        { "data": "id", "autoWidth": true },
                                        { "data": "updatedDate", "autoWidth": true, type: 'date-dd-mmm-yyyy', targets: 0 },
                                        { "data": "deviceid", "autoWidth": true },
                                        { "data": "devicename", "autoWidth": true },
                                        { "data": "temp", "autoWidth": true },
                                        { "data": "faht", "autoWidth": true }
                                ]
                            });
                        });

c# code

public  ActionResult loaddata()
{ 
    using (smartpondEntities dc = new smartpondEntities())
    {
        var data = dc.Temperatures.OrderBy(a => a.id).ToList();
        return Json(new { data = data}, JsonRequestBehavior.AllowGet);
    }
}

json sample data

[{"id":1,"updatedDate":"2018-11-23T07:49:35.073","DeviceTime":null,"deviceid":1,"devicename":"aaaa","temp":28.50,"faht":87.90},{"id":2,"updatedDate":"2018-11-23T07:49:42.1","DeviceTime":null,"deviceid":1,"devicename":"aaaa","temp":28.50,"faht":87.90}]

output

/Date(1542939575073)/

exp op

23 Nov 2018 13:10:10

Date is fine. It's just a matter of formatting to string. You need to format your date to expected when you displaying it. — Renatas M.
– Renatas M., Commented Nov 23, 2018 at 13:22

Wilmer Ofelio Alama Seminario · Accepted Answer · 2018-11-23 16:04:26Z

1

i use moment.js for datetimes (docs). so in your render:

{
    title: "Date",// name 
    render: function (data, type, row) {//data
        return moment(row.updatedDate).format('DD/MM/YYYY hh:mm:ss');
    }
}

answered Nov 23, 2018 at 16:04

Wilmer Ofelio Alama Seminario

1481 silver badge9 bronze badges

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

Comments

Gokul Maha · Accepted Answer · 2018-11-23 14:01:51Z

0

You should use a render function to format/customize your data

For Ex:

"columns": [
{ "data": "engine" },
{ "data": "browser" },
{
  "data": "platform",
  "render": function ( data, type, row, meta ) {
               return ConvertToDate(data);
            }
}

Convert your date in ConvertToDate(data) function.

function ConvertToDate(data){
     return data;//Converted date
}

edited Nov 23, 2018 at 14:01

answered Nov 23, 2018 at 13:46

Gokul Maha

2981 gold badge8 silver badges26 bronze badges

2 Comments

krishnamohan rao Over a year ago

error saying - "ConvertToDate is not defined", do i need to make a another function

Gokul Maha Over a year ago

you need to add a function named ConvertToDate(date)

Imran · Accepted Answer · 2022-08-19 06:28:30Z

0

To render date format in Angular-Datatables, first you need to install npm moment

npm install moment --save

import * as moment from 'moment'; // import moment wherein you are using in component

{
  title: 'CreatedAt',
  data: 'CreatedAt',
  render: (data:any,type:any,full:any)=>{
    return moment(data).format('L'); 
// more related moment format you can check here - https://momentjs.com
   }
}

edited Aug 19, 2022 at 6:28

answered Aug 19, 2022 at 6:26

Imran

11 bronze badge

Collectives™ on Stack Overflow

Datetime value not showing properly in jQuery data table

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related