SQLite time() Function

The SQLite time() function converts a time value specified by a time value and modifiers to a time string in HH:MM:SS format.

Syntax

Here is the syntax of the SQLite time() function:

time(time_value [, modifier, modifier, ...])

Parameters

time_value

Optional. A time value. The time value can be in any of the following formats, as shown below. The value is usually a string, but in the case of format 12 it can be an integer or a floating point number.

  1. YYYY-MM-DD
  2. YYYY-MM-DD HH:MM
  3. YYYY-MM-DD HH:MM:SS
  4. YYYY-MM-DD HH:MM:SS.SSS
  5. YYYY-MM-DDTHH:MM
  6. YYYY-MM-DDTHH:MM:SS
  7. YYYY-MM-DDTHH:MM:SS.SSS
  8. HH:MM
  9. HH:MM:SS
  10. HH:MM:SS.SSS
  11. now - the current date and time
  12. DDDDDDDDDD.dddddd - Julian days number with fractional part
modifier

Optional. You can use zero or more modifiers to change the time value time_value. Multiple modifiers are applied sequentially from left to right. You can use modifiers like this:

  1. NNN days- Add NNN days to the time value
  2. NNN hours- Add NNN hours to the time value
  3. NNN minutes- Add NNN minutes to the time value
  4. NNN.NNNN seconds- Add NNN.NNNN seconds to the time value
  5. NNN months- Add NNN months to the time value
  6. NNN years- Add NNN years to the time value
  7. start of month- Fall back to the beginning of the month in time_value
  8. start of year- Fall back to the beginning of the year in time_value
  9. start of day- Fall back to the beginning of the day in time_value
  10. weekday N- Advance time_value ​​to weekday N
  11. unixepoch- Unix timestamp for now
  12. julianday- The Julian calendar days for now
  13. auto
  14. localtime- The current time
  15. utc- The utc time

The NNN represents a number. Can be a positive or negative number. If NNN is negative, it means subtraction.

Return value

The SQLite time() function returns a time string in HH:MM:SS format. If no arguments are provided, the time() function returns the current time.

Examples

Here are some examples to show usages of the SQLite time() function.

  • Get the current time using the SQLite time() function:

    SELECT time();

    time()
--------
08:00:01

    Alternatively, you can use the SQLite time() function with a time value 'now' to get the current time:

    SELECT time('now');

    time('now')
-----------
08:00:19

  • Use the SQLite time() function to get the time part of a datetime value:

    SELECT time('2022-07-26 12:01:01');

    time('2022-07-26 12:01:01')
---------------------------
12:01:01

  • Use the SQLite time() function to get the time after 10 minutes from the current time:

    SELECT time('now'), time('now', '10 minutes');

    time('now')  time('now', '10 minutes')
-----------  -------------------------
08:03:02     08:13:02