i wanna do something like that
TIMESTAMPDIFF(SQL_TSI_MINUTE, TIMESTAMP ( min("Time"."START_TS")), TIMESTAMP (max("Time"."END_TS")))
i have to get first date and last date, and show the diff.
first date and last date of what?
is that by Year that means of today?
min is 1 jan and max is 15 jan like that?
You might need to use group by clause
So how is the user control I want to get the first date he entered (dd / mm / yyy h: m: s) and calculate the last recorded time. and show this difference in minutes
You want for particular date
then you should use as below
TIMESTAMPDIFF(SQL_TSI_MINUTE, TIMESTAMP ( min("Time"."START_TS" by date)), TIMESTAMP (max("Time"."END_TS" by date)))
please, could you delete this post... i found the error was not what i thought
delete? just mark it answered