Parse date format with timezone CST

[phelim13 (PhelimXue)]

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?

[spinscale (Alexander Reelsen)]

Hey,

what Elasticsearch version are you trying this on?

--Alex

[phelim13 (PhelimXue)]

Hello,

I using Elasticsearch 6.3.0

[spinscale (Alexander Reelsen)]

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.

[phelim13 (PhelimXue)]

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

[spinscale (Alexander Reelsen)]

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