Hi
I'm using Documentum version 16.7.0000.0810 and while using the datediff function of DQL, I found out that the date difference in days between 30/10/2022 and 31/10/2020 is 1.0416667 days which is equal to 1 day and 1 hour when you would expect 1.0 days.
This is correct because I am in Belgium, and we had a switch from DST (Daylight saving time) to Standard Time on 30 October 2022. I did not expect this because in my opinion Documentum does not have knowledge of the time zone in which it operates.
Below the used DQL statement and the result:
SELECT date('10/30/2022 00:00:00','mm/dd/yyyy hh:mm:ss') as problem_date,
datediff(day,date('10/29/2022 00:00:00','mm/dd/yyyy hh:mm:ss'),date('10/30/2022 00:00:00','mm/dd/yyyy hh:mm:ss')) as before_problem,
datediff(day,date('10/30/2022 00:00:00','mm/dd/yyyy hh:mm:ss'),date('10/31/2022 00:00:00','mm/dd/yyyy hh:mm:ss')) as problem,
datediff(day,date('10/31/2022 00:00:00','mm/dd/yyyy hh:mm:ss'),date('11/01/2022 00:00:00','mm/dd/yyyy hh:mm:ss')) as after_problem
FROM dm_document
ENABLE(RETURN_TOP 1)
Is there anyone which can answer why the datediff adds 0.0416667 days when you would normally expect that 30 and 31 October are 1 day apart?
