SQLite Date Function

The SQLite "DATE" function is used to retrieve the date and return it in 'YYYY-MM-DD' format.

Syntax:

Here, timestring is a date value which can be anyone of the following:

modifier1, modifier2, ... modifier_n: modifiers are optional. These are used with timestring to add or subtract time, date or years.

Example1:

Retrieve current date:

Output:

Example2: Retrieve First Day of the Month:

There are 4 ways to find out first day of the month:

Output:

Example3: Retrieve last day of the month:

Date function can be used to retrieve the last day of the month. There are 4 ways to find out last day of the month:

Output:

Example4: Add/ subtract years to Current date:

Add and subtract 5 years to current date:

Output:

Example5: Add/ subtract days to Current date:

By the same above way you can add and subtract days to the date:

Output: