Hi,
I am syncing data from our SQL servers where dates are already stored in UTC timezone eg. 2016-09-01 03:00:00.000
Now when i sync this data to ES, it applies UTC on top of this UTC again.
How can I prevent UTC timezone conversion for the index? Will creating a dynamic_template like below help and prevent UTC conversion when stored in ES?
POST /test
{
"mappings": {
"test": {
"dynamic_templates": [
{
"dates_ignore_malformed": {
"path_match": "*",
"match_mapping_type": "date",
"mapping": {
"format": "yyyy-MM-dd HH:mm:ss.SSS",
"ignore_malformed": true
}
}
}
]
}
}
}