Date and Time data types in SQLite

Current date and time

Report a typo

Let's imagine that the following SQLite requests are made on 31.12.2099 at 23:59:59.

Match requests with the correct result:

Match the items from left and right columns

SELECT DATE('now')

SELECT TIME('now')

SELECT DATETIME('now')

2099-12-31

23:59:59

2099-12-31 23:59:59

___

Create a free account to access the full topic