Date and Time data types in SQLite

Day difference

Report a typo

Chose correct ways of how to calculate difference between two days:

Select one or more options from the list

strftime('%d', 'YYYY-MM-DD') - strftime('%d', 'YYYY-MM-DD')

julianday('YYYY-MM-DD') - julianday('YYYY-MM-DD')

age(timestamp1, timestamp2)

DATEDIFF(interval, date1, date2)

___

Create a free account to access the full topic