When (time_to_sec(timediff(concat(date(time_1)," ",time(time_2)),concat(date(time_1)," between 0 and 435 Then -abs(time_to_sec(timediff(concat(date(time_1)," ",time(time_2)),concat(date(time_1)," (time_to_sec(timediff(concat(date(time_1)," ",time(time_2)),concat(date(time_1)," between -60 and 0 then 0 THEN -abs(time_to_sec(timediff(time_1,concat(date(time_1)," abs(time_to_sec(timediff(time_1,concat(date(time_1)," end) as gg1, THEN -abs(time_to_sec(timediff(time_1,concat(date(time_1)," time_to_sec(timediff(time_1,concat(date(time_1)," between 8 THEN -abs(time_to_sec(timediff(time_1,concat(date(time_1)," time_to_sec(timediff(time_1,concat(date(time_1)," between 495 and 855
When time_to_sec(timediff(time_1,concat(date(time_1)," between 60 and 495 Select (case when time_to_sec(timediff(time_1,concat(date(time_1)," between 0 and 60 then 0 Code below will run as intended but may need some improvements. Same question but my own solution is different. If any of you has a better solution, it will benefit everyone. My previous question here is still same but i was working on it now i have a solution for it.
0 kommentar(er)
