Time spent between 00:00:00 and 01:59:59 appear on the day before

Question

Hello

When declaring time spent over task. I figured out that if the time of the date on which we declare the time is comprised between  00:00:00 and 01:59:59 (included) then the time declared appear on rthe day before when looking at "Reporting>Timesheet analysis"

/Example: 2 hours entered on a task at the date October, 5th at 01:15:00 appear in the report as 2 hours spent on the October 4th. /

This is not coherent and is priobably not the expected behaviour.

I can not force my users to spe

Bole · Answer

Time zones and server setup is the topic you should read about..
Short version: server should always be in UTC time, users should have time zone set up corectly,
Server will always write time and datetime records in UTC without timestamp... and recalculate in current user timezone on view rendering.

My guess is that your server time is something like GMT +1 or GMT+2 ( or any timezone with this characteristic)...
To check that info, go to console and type: *date +%Z  *
and if it is not UTC you c

flg · Answer

Thanks for having taken the time to answer.

I set the server timezone as UTC as suggested. This may impact the postgresql server timezone which use by default the server's one (timezone = 'localtime' in the postgresql config file).

-> The problem is still present

I also changed the config file of postgresql from /timezone = 'localtime'/ to /timezone = 'UTC'/ and results are the same

Practical example based on my current configuration:

The server is set as UTC, the postgresql is set as the

This question has been flagged

Enjoying the discussion? Don't just read, join in!