Howdy,
Considering that SQLite doesn't seem to have a data or DateTime column type.
How can I calculate trip duration? The data as a started_at and ended_at timestamps. Can I use a CAST function ie SELECT CAST("2017-08-29" AS DATE);?
TIA,
David
Howdy,
Considering that SQLite doesn't seem to have a data or DateTime column type.
How can I calculate trip duration? The data as a started_at and ended_at timestamps. Can I use a CAST function ie SELECT CAST("2017-08-29" AS DATE);?
TIA,
David