SQLite Forum

Calculating duration in ISO8601 timestamp
Login
Ah! Good tip.


Until the time is using a decimal, does that mean the `julianday` function and friends won't know how to read the datetime as its stored?

```
select
	min(strftime('%Y-%m-%d %H:%M:%S.%f',datetime))  as start
From
	table1
```

Doesn't give me anything back.

Neither does dropping the .%f:   
`min(strftime('%Y-%m-%d %H:%M:%S',datetime))  as start`