Hi,
Assume this is the start time of an event:
`2021-07-19 08:43:46:956`
and this is the end time:
`2021-07-20 10:26:41:357`
The times are using 24 hour timestamps.
Can the duration be calculated between these?
**What I've tried:**
```
select
min(datetime) as Start,
max(datetime) as End,
datetime(max(datetime)) - datetime(min(datetime)) as duration
from
table1
```
...
```
select
strftime(max(datetime)) as max,
strftime(min(datetime)) as max,
strftime(max('%Y-%m-%d %H:%M:%S',datetime)) - strftime(min('%Y-%m-%d %H:%M:%S',datetime)) as Duration
from table1
```
...
```
select
start,
end,
duration
from (
select
min(datetime) as start,
max(datetime) as end,
julianday('datetime') - julianday('now') as duration
from table1
);
```
Results are always blank or 0. Clearly it can't be! The columns are of 'text'. Do I need to cast it to something else?
Thanks!