Time Difference in Minutes

agolla2

CASE
WHEN Hospital Ready Time (UTC) IS NOT NULL AND Video Start Time (UTC) IS NOT NULL THEN
ABS(UNIX_TIMESTAMP(Hospital Ready Time (UTC)) - UNIX_TIMESTAMP(Video Start Time (UTC))) / 60
ELSE NULL
END

I am trying to find the difference between 2 timestamps. I am using the above beast mode calculation but it is giving me syntax error. Can anyone please help?

GrantSmith

You can simplify your beast mode. If either of your fields are NULL then the entire subtraction will be NULL.

(UNIX_TIMESTAMP(`Hospital Ready Time (UTC)`) - UNIX_TIMESTAMP(`Video Start Time (UTC)`)) / 60 

GrantSmith

You can simplify your beast mode. If either of your fields are NULL then the entire subtraction will be NULL.

(UNIX_TIMESTAMP(`Hospital Ready Time (UTC)`) - UNIX_TIMESTAMP(`Video Start Time (UTC)`)) / 60