View TimeDiff DateTime: Different results

PHPMaker General Discussion (PHPMaker)
1

Hi,

I am using the following statement in view (Create View) and am getting diffrent results.z.Start: 2022-10-02 05:00:00
z.End: 2022-10-03 16:15:00TimeDiff(z.End, z.Start) AS DiffeResult in phpmaker View: 11:15:00
Result in DB: 35:15:00But in the list table it is showing the correct result as 35:15:00

mpol_ch

2

If you create a view with TimeDiff(), MySQL returns the field as a TIME field so it will be formatted as time by default (35 - 24 = 11), you may try and remove the format of the field (under View Tag panel) as “Time”.