In the DB table t_lgyyyymm, you will see SRVDT but SRVDT is not event happened time. It is only the time the DB is synchronized to the server. Thus, you need to check DEVDT if you want to check out what time the event actually happened.
The thing is that DEVDT is in Unix time so it is not comfortable to check the date-time. To check this out, you may want to use the query and create a new table to see 'Human format date', not Unix time.
Maria DB Query ※ from_unixtime command returns date with timezone on your server.
SET time_zone=UTC+your device time zone;
select *, from_unixtime(DEVDT) as Device_time from t_lgyyyymm;
For example, if your device has been to UTC+9 and you are searching log for Jan 2020, then you can call the query below.
SET time_zone='+09:00';
select *, from_unixtime(DEVDT) as Device_time from t_lg202001;
MSSQL
Select dateadd(S, DEVDT, '1970-01-01 your time zone') DeviceTime, * From T_LGyyyymm
For example, if your device has been to UTC+9 and you are searching log for Feb 2020, then you can call the query below.
Select dateadd(S, DEVDT, '1970-01-01 09:00:00:000') DeviceTime, * From T_LG202002
Result
