Hi Erik,
Date times are stored in the database in the server time, which is commonly UTC for servers in Europe.
In reactive and mobile applications, the date time is automatically converted to the client timezone. For example, if you have 2021-11-11 08:00:00 in the database in UTC and you open the app in a device with UTC + 1 timezone, then you will be seeing 2021-11-11 09:00:00. The same way if your device is in UTC + 10, then you would be seeing 2021-11-11 18:00:00.
When you are testing the query, there is no client-side to convert it automatically, so you see the date time as it is in the database (in the aforementioned example in UTC, 2021-11-11 08:00:00).
Kind Regards,
João