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

hamza_123

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

Hi @hamza_123,

 

Have you tried the function TIMEDIFF?

That should do it. 

 

GrantSmith

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