Question

What is the use of date() function in SQLite?

Answer 1

The SQLite date() function is used to fetch the date and show it in 'YYYY-MM-DD' format.

Syntax:

date(timestring, [ modifier1, modifier2, ... modifier_n ] )