If you are considering to create a database link program with BioStar database with your third party software, please do not take logs from the T&A database. 

The T&A database syncs the logs from the AC database, so it is best to use the logs in the AC database for a database link.  

Refer to the article below: 

[BioStar 2] BioStar 2.5 Database Table


However if you would still like to compare the logs shown in BioStar 2 with the logs in the T&A database for troubleshooting purposes, you can compare as below. 


The important thing you should notice is that the devdt (log time) is based on UTC +0 in the database. 

When the log shows in BioStar 2 client, it is applying the UTC preference time you have configured on the client. 


Refer to the image below from the punchlog table. 

image


A closer look: 

image


Log in the punchlog table shows as 4:23 but in BioStar 2 event log it appears as 13:23.
This is because I have applied the web client time zone as UTC +9 and device time zone as +9. 


image


image