Back to list SQLite How to Get the Current Date in SQLite Database: SQLite Operators:DATE(‘now’), DATE() Problem: You’d like to get the current date in an SQLite database. Solution: We’ll use the function DATE() to get the current date. Here’s the result of the query: 2019-10-15 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: SELECT DATE(); Recommended courses: SQL Basics Standard SQL Functions SQL Practice Set Recommended articles: 18 Useful Important SQL Functions to Learn ASAP Performing Calculations on Date- and Time-Related Values How Often Employees Are Running Late for Work: SQL Datetime and Interval SQL Arithmetic See also: How to Format a Datetime in SQLite How to Get the Current Time in SQLite How to Add a Month to a Date in SQLite Tags: SQLite Subscribe to our newsletter Join our weekly newsletter to be notified about the latest posts.