How to calculate different in seconds between two timestamps in Beast Mode?

hamza_123 · December 2019

I am using the DATEDIFF function in the beast mode but it gives me a value which is not in seconds.

Could anyone please explain how to calculate the difference ins seconds between two timestamps

Koen · December 2019

Hi @hamza_123,

Have you tried the function TIMEDIFF?

That should do it.

GrantSmith · August 2020

Hi @hamza_123

You can utilize unix_timestamp function to calculate the number of seconds since 1970-01-01. With some simple math you can get the difference in seconds.

(UNIX_TIMESTAMP(`EndTime`) - UNIX_TIMESTAMP(`StartTime`))

I wrote a more advanced summary of this you can read here: https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Date-Calculations-minutes-and-seconds/m-p/49259/highlight/true#M8465

How to calculate different in seconds between two timestamps in Beast Mode?

Comments

Categories