File
Add library
Share
Login or Register
Help
HTMLSaved
 
<!DOCTYPE html>
<html>
  <head>
    <script src="https://code.jquery.com/jquery-1.11.3.min.js"></script>
    <link href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/5.3.0/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
    <link href="https://cdn.datatables.net/v/bs5/jq-3.7.0/jszip-3.10.1/dt-2.1.8/af-2.7.0/b-3.1.2/b-colvis-3.1.2/b-html5-3.1.2/b-print-3.1.2/cr-2.0.4/date-1.5.4/fc-5.0.3/fh-4.0.1/kt-2.12.1/r-3.0.3/rg-1.5.0/rr-1.5.0/sb-1.8.1/sp-2.3.3/sl-2.1.0/sr-1.4.1/datatables.css" rel="stylesheet" type="text/css" />
    <script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.29.2/moment.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/5.3.0/js/bootstrap.bundle.min.js"></script>
    <script src="https://cdn.datatables.net/v/bs5/jq-3.7.0/jszip-3.10.1/dt-2.1.8/af-2.7.0/b-3.1.2/b-colvis-3.1.2/b-html5-3.1.2/b-print-3.1.2/cr-2.0.4/date-1.5.4/fc-5.0.3/fh-4.0.1/kt-2.12.1/r-3.0.3/rg-1.5.0/rr-1.5.0/sb-1.8.1/sp-2.3.3/sl-2.1.0/sr-1.4.1/datatables.js"></script>
​
    <meta charset=utf-8 />
    <title>DataTables - JS Bin</title>
  </head>
  <body>
    <div class="container">
      <table id="example" class="display nowrap" width="100%">
      </table>
    </div>
  </body>
</html>
​
CSSSaved
 
body {
  font: 90%/1.45em "Helvetica Neue", HelveticaNeue, Verdana, Arial, Helvetica, sans-serif;
  margin: 0;
  padding: 0;
  color: #333;
  background-color: #fff;
}
​
JavaScriptSaved
 
DataTable.render.mydatetime = function (fmt) {
  return function (data, type, row) {
    if (type === 'type' || type === 'sort') {
      if (data == null) {
        return null;
      }
      return data.startsWith('0000-00-00') ? null : data;
    }
    return data == null ? null : moment(data).format(fmt);
  };
};
​
var table = $('#example').DataTable({
  ajax: "/examples/ajax/data/objects.txt",
  columns: [
    {
      data: 'name',
      title: 'Name',
    },
    {
      data: 'position',
      title: 'Position',
    },
    {
      data: 'office',
      title: 'Office',
    },
    {
      data: 'start_date',
      title: 'Start date',
      render: DataTable.render.mydatetime('DD.MM.YYYY'),
    },
    {
      data: 'salary',
      title: 'Salary',
    },
  ],
  layout: {
    topStart: 'pageLength',
    top2Start: {
      buttons: [
        {
          className: 'btn-sm',
          extend: 'searchBuilder',
        },
      ],
    },
  },
});
​
​
​
​
Output

This bin was created anonymously and its free preview time has expired. Get a free unrestricted account

Dismiss x
public
Bin info
anonymouspro
0viewers