Computer scienceFundamentalsSQL and DatabasesDBMSSQLite

Date and Time data types in SQLite

Theory

Date difference

Report a typo

Match below expressions with correct date interval they would return in SELECT request:

Match the items from left and right columns
strftime('%d','2099-02-15') - strftime('%d', '2099-02-10');
strftime('%m','2099-12-15') - strftime('%m', '2099-01-10');
strftime('%Y','2099-12-15') - strftime('%Y', '2059-01-10');
5
40
11
___

Create a free account to access the full topic