Can't remove hours and minutes from datatable

Question

I'm trying to get release date field with y-m-d format.. Actually time format (for y-m-d) seems fine but also it gives h:m:s too, I changed time format at server side and removed h:m:s but datatable still shows them

What I get

2012-04-11 00:00:00

What I want

2012-04-11

Released_at field (Metronic theme - json datatable)

{
  field: "released_at",
  title: "Release Date",
  type: "date",
  format: "YYYY/MM/DD"
}

time format (I'm using laravel framework)

protected $dateFormat = "Y-m-d";

How do I fix this ?

Answer 1

Datatable accept column type same as mysql type.

You are trying to convert mysql dateTime column to Date in datatable, which is not possible from datatable.

In your code you have declared

format: "YYYY/MM/DD" // but actual type is dateTime as per mysql.So it will append time next to it.

If you are storing only date in mysql then you can change column type to Date, and your problem gets solved.

And if you want to convert string to date in laravel you can follow this post.