Hi Everyone,
Im trying to add Logs vom a MSSQL Database to my ELk-Stack.
I had some trouble regarding the Timezone.
I want a field with the UTC Time (will be the @timestamp field) i had problems with converting the field "requestdate" directly.
So i added to the query the part
RequestDate AT TIME ZONE 'UTC' AS UTCDate
In the MS-SQL Server Managemnt Studio result i see the following
When i copy the Query to the logstash conf file and execute them i get the resullts. All fields are correct, execpt the utcdate field.
"utcdate":"2020-01-18T12:58:58.740Z"
As you can see the date is exectly 2 days behind the real date in UTC.
in the conf file i have no filter and as output stdout { codec => json_lines }
I hope you can help me.
Best