Discussion:

The SQLite function DATE(‘now’) returns the current date as a text value. It uses the ' YYYY-MM-DD ' format, where YYYY is a 4-digit year, MM is a 2-digit month, and DD is a 2-digit day of the month.

This function takes one argument: the text ‘now’ indicates the current date and time. However, you don’t have to add it, as ’now’ is the default. You can just use: