Converting dateformat to "seconds since 1970" in custom question possible?

Get Help
1

Hi everyone,

in my table I have two timestamps, start and end of a time tracking.
They get displayed like this:
image

I want to calculate how much time passed between those timestamps and express it in a custom column.
Usually I would convert thos dates to "seconds since 1970" format and calculate from there but i am not sure how to do that in metabase without using sql.
Is there a way to do it in a custom question and not write a native query?

2

Hi @Cpt_Trips
Metabase does not have a function to convert timestamps like that. There's a request for being able to create a diff between two dates and return the difference in defined value:
https://github.com/metabase/metabase/issues/16870 - upvote by clicking :+1: on the first post