How to Get the Current Time in SQLite Database: SQLite Operators: TIME('now') TIME() Table of Contents Problem: Solution: Discussion: 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: Standard SQL Functions Cheat Sheet 18 Useful Important SQL Functions to Learn ASAP Performing Calculations on Date- and Time-Related Values 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 Subscribe to our newsletter Join our monthly newsletter to be notified about the latest posts. Email address How Do You Write a SELECT Statement in SQL? What Is a Foreign Key in SQL? Enumerate and Explain All the Basic Elements of an SQL Query