Date format incorrect results

Elastic Stack Elasticsearch
23

Here is what I can tell.

So you get data from a table tbl_ihale.
The date is ihale_tarihi.
The exact format elasticsearch is expecting is YYYY-mm-dd HH:MM:SS (as you defined it).

So after the injection is over, what gives the following queries?

  • GET /ihaleler/ihale/_search?size=1
  • GET /ihaleler/ihale/_mapping?pretty
26

As you can see, your mapping is incorrect.

Fix it.

27

It was this time. :relaxed:
I made before the date on sense editor. Then I run other code on PHP.
The following code does not work:

$myTypeMapping['properties']['$ihale_tarihi']['type']='date';
$myTypeMapping['properties']['ihale_tarihi']['index']='analyzed';
$myTypeMapping['properties']['$ihale_tarihi']['format']='yyyy-MM-dd HH:mm:ss';

I did just date parameter on the editor:

PUT ihaleler/ihale/_mapping
{
  "properties": {
    "ihale_tarihi": {
      "type": "date",
      "format": "yyyy-MM-dd HH:mm:ss"
    }
  }
}

really thank you so much
I am thankful to you