Okey so i cahnged the time-zone and it now works as expected, but i think i found the reason why im seeing the reuslts i am,
in the cdr-files im seeing the time for a call as 07:41:49 and the time for the call was 07/03/2024 9:41:49 AM
So im guessing that the issue is comming from 3cx since it is not 24H Clock.. and therefor the time is not correct and so my results in the DB is of by 2h
I had a look today to the cdr files you gave me and the records in the db corresponding to these files , and don't have any problem with date time , there are the same in both
in the cdr-files im seeing the time for a call as 07:41:49 and the time for the call was 07/03/2024 9:41:49 AM So im guessing that the issue is comming from 3cx since it is not 24H Clock.. and therefor the time is not correct and so my results in the DB is of by 2h
Originally posted by @MrGlenn-tech in https://github.com/dorel14/3CX-Cdr-Tcp-Server/issues/52#issuecomment-2205346203