Back to list SQLite How to Get the Current Time in SQLite Database: SQLite Operators:TIME('now'), TIME() Problem: You’d like to get the current time in an SQLite database. Solution: We’ll use the function TIME() to get the current time. SELECT TIME(‘now’); Here’s the result of the query: 10:56:12 Discussion: The SQLite function TIME() returns the current time as a text value. It uses the 'hh:mm:ss' format, where hh is a 2-digit hour, mm is a 2-digit minute, and ss is a 2-digit second. This function has only one argument: the text value ‘now’, which indicates that the current date and time should be returned. You can omit this argument, as it is the default. Here is the shorter version of this function: SELECT TIME(); 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 Date 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.