w3resource

SQLite time() function

Description

SQLite TIME() extracts the time part of a time or datetime expression as string format.

The time() function returns the time as HH:MM:SS.

Syntax:

time(timestring, modifier, modifier, ...)

Example-1:

If you want to get the current time the following SQL can be used.

SELECT time('now') as "Current Time";

or

SELECT time() as "Current Time";

Here is the result.

Current Time
------------
10:37:30

Example-2:

The following statement will return the time portion from the given date-time value 2014-10-07 15:45:57.005678.

SELECT time('2014-10-07 15:45:57.005678') as "Only time part";

Here is the result.

Only time part
--------------
15:45:57

Example-3:

If you want to get the time after 15 minutes from the current time, the following SQL can be used.

SELECT TIME('now'),TIME('now','+15 minutes');

Here is the result.

TIME('now')  TIME('now','+15 minutes')
-----------  -------------------------
11:22:26     11:37:26

Example-4:

If you want to get the time after 60 seconds from the current time the following SQL can be used.

SELECT TIME('now'),TIME('now','+60 seconds');

Here is the result.

TIME('now')  TIME('now','+60 seconds')
-----------  -------------------------
11:24:14     11:25:14

Previous: DATE
Next: DATETIME



Become a Patron!

Follow us on Facebook and Twitter for latest update.

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://www.w3resource.com/sqlite/sqlite-time.php