sqliteHow do I use the SQLite YEAR function?
The SQLite YEAR function is used to extract the year from a date value. It takes a single argument, which must be a valid date value. The output is an integer value representing the year.
For example:
SELECT YEAR('2019-11-02');
Output example
2019
The code above uses the YEAR function to extract the year from the date value '2019-11-02'. The output is the integer value 2019.
The YEAR function can also be used in combination with other date functions to extract more specific information. For example, the following code will extract the year from the current date:
SELECT YEAR(CURRENT_DATE);
Code explanation
- SELECT: the keyword used to retrieve data from the database
- YEAR(): the function used to extract the year from a date value
- '2019-11-02': the argument passed to the YEAR function, representing a valid date value
- Output: the integer value representing the year extracted from the date value
- CURRENT_DATE: the function used to get the current date
Helpful links
More of Sqlite
- How do I use the SQLite ZIP VFS to compress a database?
- How can I use SQLite with Zabbix?
- How do I format a date in SQLite using the YYYYMMDD format?
- How can I use SQLite with Unity to store and retrieve data?
- How do I use SQLite xfilter to filter data?
- How can I use SQLite with Xamarin Forms and C#?
- How do I use SQLite with Visual Studio?
- How do I decide between using SQLite and PostgreSQL for my software development project?
- How do I use an online SQLite viewer?
- How can I use an upsert statement to update data in a SQLite database?
See more codes...