Calculating the difference in time

Get Help
1

hello,

I have two columns, that are showing time with date as in the attached image

23%20PM
23%20PM365×547 32.1 KB

I need a custom column to calculate the difference between those two columns, can someone please help in here, how can I do that?

Thanks

2

Afaik by searching on google about this question, Metabase currently doesn't support interval.

You can try to make SQL query as per @flamber suggested : https://stackoverflow.com/questions/17833176/postgresql-days-months-years-between-two-dates

Source topic : Calculating Days Between Two Dates

Cheers

3

Looks like this may be added now: DatetimeDiff

4

It was added versions ago