Date and Time data types in SQLite

Parts of dates

Report a typo

Match below expressions with correct time value they would return:

Match the items from left and right columns

SELECT strftime('%H', '2099-03-05 12:59:34');

SELECT strftime('%M', '2099-03-05 05:36:17');

SELECT strftime('%S', '2099-03-05 23:24:29');

___

Create a free account to access the full topic