Parse date format with timezone CST

Elastic Stack Elasticsearch
1

hello,

in my case, my log insert logTime like 19-5-21 11:00:00:000 CST
I parse date with format yy-M-d HH:mm:ss:SSS zzz
everything is looks good

but when I query this date field, I found that timezone is wrong
because I want CST( C hina S tandard T ime) => UTC+8
not CST( C entral S tandard T ime) => UTC-5
Is there any way to solve this problem?

2

Hey,

what Elasticsearch version are you trying this on?

--Alex

3

Hello,

I using Elasticsearch 6.3.0

4

It does not look like joda time is interpreting CST as china standard time, so I think the best way to solve this would be to specify the offset as -08:00 and use Z in the format.

5

yes I think so too, but my dilemma is that LOG is not in my control. :joy:
Thanks for your reply

6

you could use an script ingest processor and modify the field then and replace CST with the offset.